Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
10 subscribers
Views
1204 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
I am attempting to define two facet options to filter a database column by wheth
lindat
over 11 years ago
I am attempting to define two facet options to filter a database column by whether it is null (in null()) or non-null (not in null()).
For a numeric column, I receive the error message: "Cannot apply operator [EQUALS] to field [price] when comparing to value [TypedValue[it=3,v=]]. (APNX-1-4203-015)"
For a varchar/string column, the "not in null()" facet option returns the appropriate rows but the "in null()" facet option returns no rows (it seems to be ignoring any rows containing null).
How can filter based upon presence/absence of a null value?...
OriginalPostID-77621
OriginalPostID-77621
Discussion posts and replies are publicly visible
0
revat.anandsongkit
Appian Employee
over 11 years ago
Presence is straight forward. For absence, i.e. null() values, consider filtering where price <> all other options
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel