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
5468 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
benjamins
over 8 years ago
@philb Using the IN operator with {null, false} returns back false only.
Im thinking of setting everything in the database to false and then tweaking my existing live instances so when I persist the CDT changes to the database, checking for null for the CDT field and if it is null, then retrieving the value from the database and setting the CDT to that, else, having a default setting to false.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
benjamins
over 8 years ago
@philb Using the IN operator with {null, false} returns back false only.
Im thinking of setting everything in the database to false and then tweaking my existing live instances so when I persist the CDT changes to the database, checking for null for the CDT field and if it is null, then retrieving the value from the database and setting the CDT to that, else, having a default setting to false.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data