A Filter allows you Use filters to display or work with a subset of data in a stream. To add a filter to the data in a stream:
- In the repository, expand the stream.
- Right-click on Filters
...
Form: Filter
...
- and
a new filter.Insert excerpt _add _add nopanel true - PhixFlow displays the filter properties.
You can also apply filters on the data that is displayed in a view; see Using Filters on Data Views.
Filter Properties
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Basic Settings
| Field | Description |
|---|---|
| Name | The name of the filter. |
| Private | Available to users with the Create Public Filters privilege.
|
| Protect during import |
|
Filter Details
...
Create a filter by adding conditions and clauses.
Field | Description |
|---|
Filter Details
Build a filter by adding conditions and clauses.
...
...
...
Add
...
Add a clause to the filter. Hover over the editor to the right of a condition to see this button.
...
Delete...
| Condition | Select one of the options
To add more conditions, hover your mouse pointer over this field to display the
| ||||||||
Hover your mouse pointer over the Condition field to display this button. | |||||||||
| Clause | Select an option from the list. PhixFlow adds more fields where you can:
| ||||||||
Hover your mouse pointer over a filter clause to display this button. |
...
| |
Indicates the value entered is a literal value. Click this icon to |
...
treat the value as an expression. |
...
Indicates the value entered is an expression. Click this icon to |
...
treat the value to a literal |
...
string. |
| 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. 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
...
See Also
...