how do I advanced filter date field for null values
Currently the value field shows a date picker by default
2 Answers
Hi,
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");
With:
$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.
PS:
– 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: http://www.phpgrid.org/get-update/
Your Answer