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).

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.