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.
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
Apply the filter without saving it.Insert excerpt _filter_apply _filter_apply nopanel true
Save without closing.Insert excerpt _save _save nopanel true
Save and close.Insert excerpt _finish _finish nopanel true
...
| Field | Description | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Add a clause to the filter. Hover over the editor to the right of a condition to see this button. | ||||||||||||||||||
| 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 Case |
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.
| ||||||||||||||||||
| 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
...
Columns that have a filter are marked with this icon: 
.
You cannot apply a column filter to percentage aggregate values.