Use filters to display or work with a subset of data in a stream.

To add a filter to the data in a stream:

1. In  the repository, expand the stream.
2. Right-click on Filters and  Add New  a new filter.

To add a filter to a view of the data in a stream:

1. In  the repository, expand the stream.
2. Expand the data view.
3. Right-click on Filters and  Add New  a new filter.

PhixFlow displays the filter properties.

You can also apply filters on the data directly in a dashboard or view; see Filters on Data Views.

For information about the properties toolbar, and about the sections Parent Details, Analysis Models, Description and Audit Summary, see Common Properties.  We recommend you always add a Description that explains the purpose of the item you are creating. 

For a full list of all the PhixFlow property tabs and windows, see Properties, Windows, Menus and Toolbars.

Basic Settings

Filter Details

To create a filter, add conditions and clauses.

Field	Description
Condition	Select one of the options Where ALL... Where ANY... To add more conditions, hover your mouse pointer over this field to display the  Add New button.
Add New	Hover your mouse pointer over the Condition field to display this button. Add another condition to your filter.
Clause	Select an option from the list. PhixFlow adds more fields where you can: select how the filter matches (for example, equals, contains, is null) enter a string that the filter uses to match the data. The string can be an expression or a literal string.
Delete	Hover your mouse pointer over a filter clause to display this button. Delete the selected clause or condition from the filter.
Literal Value	Indicates the value entered is a literal value. Click this icon to treat the value as an expression.
(Expression String)	Indicates the value entered is an expression. Click this icon to treat the value to a literal string.
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). Error rendering macro 'excerpt-include' : No link could be created for '_check_box_ticked'.  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.