Overview

Use filters to display a sub-set of data in a chart. When you create or edit a filter, PhixFlow displays a window where you can specify a set of clauses. Each clause contains a number of conditions.

...

You can name and save filters for future use, or use them temporarily. 

For information about other settings, see Form Descriptions.

Filter Window

Toolbar

• Insert excerpt
  _filter_apply _filter_apply nopanel true

   Apply the filter without saving it.

• Insert excerpt
  _save _save nopanel true

   Save without closing.

• Insert excerpt
  _finish _finish nopanel true

   Save and close.

...

Field	Description
Insert excerpt _add _add nopanel true	Add a clause to the filter. Hover over the editor to the right of a condition to see this button.
Insert excerpt _delete _delete nopanel true	Delete the selected clause or condition from the filter. Hover over the editor to the right of a condition or clause to see this button.
	Indicates the value entered is a literal value. Click this icon to switch the value as an expression.
	Indicates the value entered is an expression. Click this icon to switch the value to a literal value.
Ignore CaseThe condition matches values ignoring case e.g. "abc" would match	Insert excerpt _check_box_untick _check_box_untick nopanel true so that, for PhixFlow instances running on Oracle or MariaDB (MySQL), the condition only matches strings that have the same capitalisation (case-sensitive). Insert excerpt _check_box_ticked _check_box_ticked nopanel true   so that the condition matches strings that have any capitalisation (case-insensitive). For example "abc" matches "abc", "Abc", "ABC", etc. The default setting is defined  For case-insensitive filters, there is no difference if the attribute is also indexed.  Whether or not the check box is ticked by default depends on the underlying stream attribute property tab → Advanced section → Filter conditions are case-independent by default. Note This option affects the behaviour of filters for PhixFlow instances running on Oracle or MariaDB (MySQL) databases. For PhixFlow instances running on a SQLServer database, filters are always case-independent.
Insert excerpt _filter_picker _filter_picker nopanel true	Display the filter picker. Click this icon to display a list of possible values to filter by. See Using Filter Pickers1261699659, below.

Description Tab

Optionally, enter a description to explain the purpose of this filter.

Some Filter Examples

Create prompt filter

...