Hey everyone, Im trying to implement a default filter for my entity b

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

Parents
  • @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.
Reply
  • @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.
Children
No Data