Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
12 replies
Answers
1 answer
Subscribers
13 subscribers
Views
5471 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Hey everyone, Im trying to implement a default filter for my entity b
benjamins
over 8 years ago
Hey everyone,
Im trying to implement a default filter for my entity backed record and return back results where a particular field is either false or null (not true). I have tried using <> true, and or(null, false) and both are failing to return back the results I need.
Anyone have any ideas on this one?
OriginalPostID-198637
OriginalPostID-198637
Discussion posts and replies are publicly visible
Top Replies
michszym
over 1 year ago
+2
suggested
Certified Associate Developer
Use a custom field and add a default value to it a!customFieldDefaultValue( value: 'recordType.booleanFieldWithNulls', default: false ) Name it something like fieldName + "NullSafe", and then filter…
Parents
0
sikhivahans
over 8 years ago
@philb I am on Appian 16.1, and prior to posting my solution I have made few tests. What I have observed is, {null, true} worked excellently whereas {null,false} didn't. And as said by you, I remember doing a similar test long ago (on 7.5 or 7.6 I guess) has resulted in error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@philb I am on Appian 16.1, and prior to posting my solution I have made few tests. What I have observed is, {null, true} worked excellently whereas {null,false} didn't. And as said by you, I remember doing a similar test long ago (on 7.5 or 7.6 I guess) has resulted in error.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data