Use SQL Pattern Match with Filters
SQL Pattern Match allows you to search for a value that is only part of the filtered field. This option is only available for certain filters.
- From the feature you want to add a filter to, select an option in the Add New Field Filter.
- Click Edit Values.
- In the Add Item field, type the string you want to find.
For example, to find both loggedin and loggedout, type log. - Select the SQL Pattern Match check box.
When you check the SQL Pattern Match box, the default pattern %your string% is used. This pattern finds any instance of your string in the field. If you want to use any other wildcard, you must type it in the Add Item field. - Click Add Item.
- (Optional) Add more items, clearing the SQL Pattern Match check box if necessary.
- Click OK.