Code snippet below shows a filter for field test whose value is reviewing.
a!queryFilter( field: recordType! a.fields.test operator: "=", value: "Reviewing" )
How can I filter field test whose values are "reviewing" or null? I should be able to get rows 1 and 2
Discussion posts and replies are publicly visible
a!queryFilter( field: recordType!a.fields.test operator: "in", value: {"Reviewing", null} )
For the record - this method will not return results where the field is "DB Null" - but it does return entries where the DB row contains a blank value (extra frustrating since the DB treats these differently but Appian gives us no direct way to control it).
This was actually my problem when I posted this question. so I was thinking if there's a method to get that as well