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.

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

underlying Attribute

sensitive by default.