Filter a value and null values

Question

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

test

1 
 reviewing

2

3 
 resolved

michszym · Answer

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.

Abhay Dalsaniya · Answer

Few points to note. 
 - Must use a!queryRecordType(). Cannot use a!queryEntity() with recordType constant as the entity. 
 - The batch size when querying record data must be between 0 and 5,000. 
 a!queryRecordType(
 recordType: cons!XXX_RECORD_EMP,
 filters: a!queryLogicalExpression(
 operator: "OR",
 filters: {
 a!queryFilter(
 field: 'recordType!{xx-xx-xx-xx-xx}Employee.fields.{xx-xx}department',
 operator: "=",
 value: "IT"
 ),
 a!queryFilter(
 field: 'recordType!{xx-xx-xx-xx-xx}Employee.fields.{xx-xx}department',
 operator: "is null"
 )
 },
 ignoreFiltersWithEmptyValues: true
 ),
 pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 50
 )
)

Abhay Dalsaniya · Answer

Just FYI, a!queryEntity() does not work for recordType. Need to use a!queryRecordType().

Filter a value and null values

Top Replies