Overview
Use filters to display a sub-set of data in a table (grid) or 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.
See also You can also use the selected data in a grid to act as a filter on the data displayed in a form; see Creating Background Filters Within a Layout.
Filter Window
Toolbar
| Insert excerpt |
|---|
| _filter_apply |
|---|
| _filter_apply |
|---|
| nopanel | true |
|---|
|
Apply the filter without saving it.- Save without closing.
| Insert excerpt |
|---|
| _finish |
|---|
| _finish |
|---|
| nopanel | true |
|---|
|
Save and close.
...
| Field | Description |
|---|
| 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. |
| Insert excerpt |
|---|
| _filter_literal |
|---|
| _filter_literal |
|---|
| nopanel | true |
|---|
|
| Indicates the value entered is a literal value. Click this icon to switch the value as an expression. |
| Insert excerpt |
|---|
| _filter_expression |
|---|
| _filter_expression |
|---|
| nopanel | true |
|---|
|
| 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 |
|---|
| 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. 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 9106735950, below. |
Description Tab
Optionally, enter a description to explain the purpose of this filter.
Some Filter Examples
Create prompt filter
...
| Tip |
|---|
There are some scenarios where PhixFlow cannot generate the list of values for a filter picker list. - pivot views
- where the underlying stream data is aggregated.
In these cases, PhixFlow automatically hides the icon | Insert excerpt |
|---|
| _filter_picker |
|---|
| _filter_picker |
|---|
| nopanel | true |
|---|
|
. |
Column Filters
When you display a data grid, for example the default stream view, you can apply filters directly to a column.
- Hover your mouse pointer over the column header to display a
| Insert excerpt |
|---|
| _filter |
|---|
| _filter |
|---|
| nopanel | true |
|---|
|
icon.
Image Added - Click the
| Insert excerpt |
|---|
| _filter |
|---|
| _filter |
|---|
| nopanel | true |
|---|
|
icon to open the filter options.
Image Added - From the drop-down, select a filter condition.
- Enter the filter value or click
Image Added to select a value from those present in the data.
To work in a larger space, to enter longer values or expressions:- either drag the bottom right corner of the value box
- or click the
Image Added Larger Editor button.
- Set whether the value is a
| Insert excerpt |
|---|
| _filter_literal |
|---|
| _filter_literal |
|---|
| nopanel | true |
|---|
|
or an | Insert excerpt |
|---|
| _filter_expression |
|---|
| _filter_expression |
|---|
| nopanel | true |
|---|
|
. - Optionally add further conditions and values.
- Click Apply.
Columns that have a filter are marked with this icon: 
Image Added.