November 2nd, 2014

Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Filtering grid containing null value(s) using relational operators
New Member
Forum Posts: 1
Member Since:
sp_UserOfflineSmall Offline


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.

Forum Timezone: Europe/Sofia

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,

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information