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
Incase, if you want empty value along with null or any other text from backend, use the following code,
a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "col2", operator: "in", value: {"Reviewing",""} ), a!queryFilter( field: "col2", operator: "is null" ) } )