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

•  and a green border indicates the value entered is an expression, allowing autocomplete of fields and Functions. Click this icon to treat the value to a literal string.
  Image Added

• 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 MySQL databases.

 so that 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

sensitive by default.