OptionalisIs null (if true is specified) or is not null (if false is specified).
OptionalequalEqual to the specified value.
OptionalnotNot equal to the specified value.
OptionaldistinctNot equal to the specified value, treating null like an ordinary value.
OptionalnotEqual to the specified value, treating null like an ordinary value.
OptionalinIncluded in the specified list.
OptionalnotNot included in the specified list.
OptionallessLess than the specified value.
OptionallessLess than or equal to the specified value.
OptionalgreaterGreater than the specified value.
OptionalgreaterGreater than or equal to the specified value.
OptionalincludesContains the specified string (case-sensitive).
OptionalnotDoes not contain the specified string (case-sensitive).
OptionalincludesContains the specified string (case-insensitive).
OptionalnotDoes not contain the specified string (case-insensitive).
OptionalstartsStarts with the specified string (case-sensitive).
OptionalnotDoes not start with the specified string (case-sensitive).
OptionalstartsStarts with the specified string (case-insensitive).
OptionalnotDoes not start with the specified string (case-insensitive).
OptionalendsEnds with the specified string (case-sensitive).
OptionalnotDoes not end with the specified string (case-sensitive).
OptionalendsEnds with the specified string (case-insensitive).
OptionalnotDoes not end with the specified string (case-insensitive).
OptionallikeMatches the specified pattern (case-sensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
OptionalnotDoes not match the specified pattern (case-sensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
OptionallikeMatches the specified pattern (case-insensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
OptionalnotDoes not match the specified pattern (case-insensitive). An underscore (_) matches any single character; a percent sign (%) matches any sequence of zero or more characters.
OptionalequalEqual to the specified value (case-insensitive).
OptionalnotNot equal to the specified value (case-insensitive).
OptionaldistinctNot equal to the specified value, treating null like an ordinary value (case-insensitive).
OptionalnotEqual to the specified value, treating null like an ordinary value (case-insensitive).
OptionalinIncluded in the specified list (case-insensitive).
OptionalnotNot included in the specified list (case-insensitive).
OptionallessLess than the specified value (case-insensitive).
OptionallessLess than or equal to the specified value (case-insensitive).
OptionalgreaterGreater than the specified value (case-insensitive).
OptionalgreaterGreater 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.’