Select one of the options

• Where ALL...
• Where ANY...

To add more conditions, click 

For each part of the clause line, select an option from the list. PhixFlow adds more fields where you can:

• select how the filter matches (for example, equals, contains, is null)
• enter a string that the filter uses to match the data. The string can be an expression or a literal string.

Click the icons:

• Insert excerpt
  _delete _delete nopanel true

   to delete the selected clause or condition from the filter.

• Insert excerpt
  _filter_literal _filter_literal nopanel true

   indicates the value entered is a literal value. Click this icon to treat the value as an expression.

• Insert excerpt
  _filter_expression _filter_expression nopanel true

   indicates the value entered is an expression. Click this icon to treat the value to a literal string.

• Insert excerpt
  _editor_expand _editor_expand nopanel true

   to open a larger editor to enter a value or expression.

This field is only available for PhixFlow instances running on Oracle or MariaDB (MySQL).

 so that, for PhixFlow instances running on Oracle or MariaDB (MySQL), the condition only matches strings that have the same capitalisation (case-sensitive).

Whether or not the check box is ticked by default depends on the underlying

attribute property tab → Advanced section → Filter conditions are case-independent by default.