Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

See also Creating Background Filters Within a Layout.

Filter Window

Toolbar

  • Insert excerpt
    _filter_apply
    _filter_apply
    nopaneltrue
     Apply the filter without saving it.
  • Insert excerpt
    _save
    _save
    nopaneltrue
     Save without closing.
  • Insert excerpt
    _finish
    _finish
    nopaneltrue
     Save and close.

...

FieldDescription

Insert excerpt
_add
_add
nopaneltrue

Add a clause to the filter. Hover over the editor to the right of a condition to see this button.

Insert excerpt
_delete
_delete
nopaneltrue

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.

Insert excerpt
_filter_literal
_filter_literal
nopaneltrue

Indicates the value entered is a literal value. Click this icon to switch the value as an expression.

Insert excerpt
_filter_expression
_filter_expression
nopaneltrue

Indicates the value entered is an expression. Click this icon to switch the value to a literal value.

Ignore Case

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
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
nopaneltrue
  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. 

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
nopaneltrue

Display the filter picker. Click this icon to display a list of possible values to filter by. See 9106735950, below.

Description Tab

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

Some Filter Examples

Create prompt filter

...