Use filters to display or work with a subset of data in a stream.
...
| Insert excerpt |
|---|
| _standard_settings |
|---|
| _standard_settings |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _property_tabs |
|---|
| _property_tabs |
|---|
| name | basic-h |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| _parent |
|---|
| _parent |
|---|
| nopanel | true |
|---|
|
Basic Settings
| Field | Description |
|---|
| Name | The Enter 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 importDuring Import | | Insert excerpt |
|---|
| _check_box_untick |
|---|
| _check_box_untick |
|---|
| nopanel | true |
|---|
|
to allow the filter settings to be changed if this filter is imported from another PhixFlow instance. If the imported configuration does not include this filter, it will be deleted. | Insert excerpt |
|---|
| _check_box_tick |
|---|
| _check_box_tick |
|---|
| nopanel | true |
|---|
|
to retain the filter settings if this filter is imported from another PhixFlow instance. To prevent orphaned filters, when a parent stream is deleted by the import, its filters are also deleted. | Expand |
|---|
| | Insert excerpt |
|---|
| _protect_import |
|---|
| _protect_import |
|---|
| nopanel | true |
|---|
|
|
|
| Include History Records | todo-Fiona |
Filter Details
To create a filter, add conditions and clauses.
...
| Condition | Select one of the options To add more conditions, | | Insert excerpt |
|---|
_new | _new |
| nopanel | true |
|---|
Hover your mouse pointer over the Condition field to display this button.
Add another condition to your filter. | | Clause | Select Clause line | For each part of the clause line, 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.
Click the icons: | Insert excerpt |
|---|
| _delete |
|---|
| _delete |
|---|
| nopanel | true |
|---|
|
| Hover your mouse pointer over a filter clause to display this button.
Delete - to delete the selected clause or condition from the filter.
| | Insert excerpt |
|---|
| _filter_literal |
|---|
| _filter_literal |
|---|
| nopanel | true |
|---|
|
| Indicates - indicates the value entered is a literal value. Click this icon to treat the value as an expression.
| Insert excerpt |
|---|
| _filter_expression |
|---|
| _filter_expression |
|---|
| nopanel | true |
|---|
|
| Indicates - indicates the value entered is an expression. Click this icon to treat the value to a literal string.
| Insert excerpt |
|---|
| _editor_expand |
|---|
| _editor_expand |
|---|
| nopanel | true |
|---|
|
to open a larger editor to enter a value or expression.
|
| 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_tick |
|---|
| _check_box_tick |
|---|
| 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. |