Custom Filter Operators for String Fields

String-filtering operations have the following requirements and restrictions:

String comparisons are case-insensitive
Wildcards are supported for substring matching. This is applicable for the like and not like operators. Use the * to filter on substrings, as shown in the following examples.
- Example of substring searches for arrays with the same prefix (for example, hqfin01). In this example, to look for all arrays in the hqfin group, the following wildcards could be used: like hqfin*
When using the in operator with a comma-separated list, do not include spaces after the commas in the list.

Operator	Description
equals	Filters data where the value of the associated field is equal to the value entered.
not equal	Filters rows where the value of the associated field is not equal to the value entered.
in	Looks for a match in a comma-separated list. Note: Do not include spaces after the commas in the comma-separated list.
not in	Returns data for values that are not in the comma-separated list. Note: Do not include spaces after the commas in the comma-separated list.
like	Matches patterns of characters. Wildcards are supported for substring matches: *, %.
not like	Returns data for strings that are not in the pattern of characters. Wildcards are supported for substring matches: *, %.
is null	Checks for null values. This is a special operation that looks for the absence of values.
is not null	Checks for non-null values. This is a special operation that looks for values that are not null.