A Filter allows you to display a subset of data. Filters can be configured locally on Views, or globally via the Editor Pane.

The form provides the standard form icons.

Field	Description
Name	The name of the filter.
Private	Available to users with the Create Public Filters privilege. Tick to make the filter available only to the user who created it. If this field is not visible to you, the filter is automatically private. Untick to make the filter available to other PhixFlow users.
Protect during import	Tick to prevent the filter being updated or deleted during import. Untick to allow the filter to be updated or deleted during import.
Filter Details
Condition	See Filter Details section below.
Description
Description	Optional: a description of the macro.

Filter Details

Build a filter by adding conditions and clauses.

Field	Description
Add	Add a clause to the filter. Hover over the editor to the right of a condition to see this button.
Delete	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	Untick so that, for PhixFlow instances running on Oracle or MariaDB (MySQL), the condition only matches strings that have the same capitalisation (case-sensitive). Tick 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. 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.
Filter Picker	Display the filter picker. Click this icon to display a list of possible values to filter by. See Using Filter Pickers, below.

Form: Filter