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.

...

Build a filter by adding conditions and clauses.

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.
	The Indicates the value entered is a literal value. Click this icon to change this, if you want to use switch the value as an expression.
	The Indicates the value entered is an expression. Click this icon to change this, if you want to enter 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. For case-insensitive filters, there is no difference if the attribute is also indexed. The default setting is defined on the underlying Stream Attribute   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

...

See Also

...