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

0 janakik over 10 years ago

Instead of mapping null(), trying converting this null to datetime
Say todatetime(null).
Hope this helps!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aksharc over 10 years ago

It gives an error: Cannot apply a filter with a blank value. (APNX-1-4203-017)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aleksi White
Appian Employee
over 10 years ago

You can use the isnull() function
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aksharc over 10 years ago

Thanks Aleski for the response. Would you please give me an example? The field contains date and time. And I want to list all the record for which that field is null. So, how can I achieve that with isnull()?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aleksi White
Appian Employee
over 10 years ago

I think I read this wrong, sorry. Instead of comparing to null(), compare to null
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aksharc over 10 years ago

Comparing with null is giving the same error! [APNX-1-4203-015]
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Aleksi White
Appian Employee
over 10 years ago

forum.appian.com/.../e-77621
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
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
0 jayashrib over 10 years ago

Hi aksharc, did you get solution to this issue? I am having exactly same issue and not sure how to solve it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 aksharc over 10 years ago

Hi Jayashri,

I haven't got any solution yet. But, why not compare it with "" (Empty String)? That may work. Let me know if it works!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel