Wildcards

There are two wildcards: _ and %

An underscore (_) matches any single character.
A percent sign (%) matches any sequence of zero or more characters.

For example, let's take the following list:

50$ discount
50% discount
No discount

If you apply a filter with:

match: 'like',
values: ['50%']

It will return not 1 but 2 rows:

50$ discount
50% discount

That is because % is a wildcard for a sequence of zero or more characters. In order to make it return only 50% discount , you will need to add an escape character ^ before the wildcard to filter for the value like so:

match: 'like',
values: ['50^%']

Also, given that the ^ character is an escape character there may be situations where you need to search for the string containing the ^ character. In these cases, (e.g. if you’re looking to filter for 50^) it should also be escaped like so:

`match: ‘like',
values: ['50^^']