Optional
isIs null (if true
is specified) or is not null (if false
is specified).
Optional
equalEqual to the specified value.
Optional
notNot equal to the specified value.
Optional
distinctNot equal to the specified value, treating null like an ordinary value.
Optional
notEqual to the specified value, treating null like an ordinary value.
Optional
inIncluded in the specified list.
Optional
notNot included in the specified list.
Optional
lessLess than the specified value.
Optional
lessLess than or equal to the specified value.
Optional
greaterGreater than the specified value.
Optional
greaterGreater than or equal to the specified value.
Optional
includesContains the specified string (case-sensitive).
Optional
notDoes not contain the specified string (case-sensitive).
Optional
includesContains the specified string (case-insensitive).
Optional
notDoes not contain the specified string (case-insensitive).
Optional
startsStarts with the specified string (case-sensitive).
Optional
notDoes not start with the specified string (case-sensitive).
Optional
startsStarts with the specified string (case-insensitive).
Optional
notDoes not start with the specified string (case-insensitive).
Optional
endsEnds with the specified string (case-sensitive).
Optional
notDoes not end with the specified string (case-sensitive).
Optional
endsEnds with the specified string (case-insensitive).
Optional
notDoes not end with the specified string (case-insensitive).
Optional
likeMatches the specified pattern (case-sensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
Optional
notDoes not match the specified pattern (case-sensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
Optional
likeMatches the specified pattern (case-insensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
Optional
notDoes not match the specified pattern (case-insensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
Optional
equalEqual to the specified value (case-insensitive).
Optional
notNot equal to the specified value (case-insensitive).
Optional
distinctNot equal to the specified value, treating null like an ordinary value (case-insensitive).
Optional
notEqual to the specified value, treating null like an ordinary value (case-insensitive).
Optional
inIncluded in the specified list (case-insensitive).
Optional
notNot included in the specified list (case-insensitive).
Optional
lessLess than the specified value (case-insensitive).
Optional
lessLess than or equal to the specified value (case-insensitive).
Optional
greaterGreater than the specified value (case-insensitive).
Optional
greaterGreater than or equal to the specified value (case-insensitive).
A filter to be used against String fields. All fields are combined with a logical ‘and.’