...
You can apply conditions to filter records to be queried
Conditions in the filters consist of leftfield, rightfield, and operator
The left field will be is the object that contains fieldsOptions: {name: "fieldName"} where fieldName is the field on which the condition is applied
The right field will be is the object that contains fieldsOptions: {value: fieldvalue} where fieldValue is the value for which the record will be searched
Operators can be equals, notEquals, lessThan, greaterThan, lessThanEqualTo, greaterThanEqualTo, contains, startsWith, endsWith, in, notIn as per the field type selected in the left field
Evaluation criteria are the logical operators to combine two or more conditions with “and” & “or”, conditions are combined with “and“ by default
...