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
Could you treat empty values as null? Because if yes, then you could use a custom field and add a default value of "" (empty string) to it
a!customFieldDefaultValue( value: 'recordType.stringFieldWithNulls', default: "")
Name it something like fieldName + "NullToEmpty", and then filter on that new field.