Forum



01:09

18/11/2013

Hi,
I've got the following example JSON data for my jqGrid table:
[ { "groupID": 1, "size": null }, { "groupID": 2, "size": 1 }, { "groupID": 1, "size": 2} ]
This corresponds to a table with 2 columns and 3 rows. Then I wanted to select only rows where the "size" attribute is greater or equal to 1. Instead of 2 rows I've got 3, including the one with "size" null. When selecting rows with "size" smaller then e.g. 3, two rows are returned correctly. I'm using jqGrid v4.5.4. As a workaround, I need to set: "size" not equals to null AND "size" >= 1 to exclude rows with null values. However, for more complex queries using the multipleSearch option I need to specify this for each column that might contain null values. Could you please help to fix this? Thanks.
Most Users Ever Online: 715
Currently Online:
24 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66