Is there a way to compare the NULL value in the facets? Basically I want to

aksharc over 10 years ago

Is there a way to compare the NULL value in the facets?
Basically I want to add a facet in the record which will show only those records which has NULL completion date. The record field is of type datetime.
Now the operators available in the facets are "=", "<>" and "between". When I use = as operator, and null() as value, it will give me an error stating, "Cannot apply operator [EQUALS] to field [ProcessInstanceCompleted] when comparing to value [TypedValue[it=3,v=]]. (APNX-1-4203-015)"
Any pointers?...

Discussion posts and replies are publicly visible

Parents

0 aksharc over 10 years ago

So, if I were to follow what Rikhi suggested, how can I set up date which can represent all the dates available in the database?
Also, as linda mentioned, she used "in null()" and "not in null()" options. How can I use that? Like, in the expression of the value? Because operator doesn't contain
"in" or "not in" option.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 aksharc over 10 years ago

So, if I were to follow what Rikhi suggested, how can I set up date which can represent all the dates available in the database?
Also, as linda mentioned, she used "in null()" and "not in null()" options. How can I use that? Like, in the expression of the value? Because operator doesn't contain
"in" or "not in" option.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data