filter date field for null values

Questionsfilter date field for null values
santosh asked 3 years ago

how do I advanced filter date field for null values
Currently the value field shows a date picker by default

2 Answers
Abu Ghufran answered 3 years ago


You need to modify lib/inc/jqgrid_dist.php and allow null search operator for datepicker.

Replace (2 occurrences):
$cols[$i]["searchoptions"]["sopt"] = array("eq","ne","gt","ge","lt","le");

$cols[$i]["searchoptions"]["sopt"] = array("eq","ne","gt","ge","lt","le","nu","nn");

This will add 'is null' and 'is not null' as search operator.

– I've also added it in dev line, so no need to worry about future version update.
– Also your technical support subscription is expired. Consider renew options for latest build:

santosh answered 3 years ago

Thanks, that worked

Your Answer

17 + 7 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?