Use filters to display or work with a subset of data in a stream.
...
To create a filter, add conditions and clauses.
| Excerpt |
|---|
| Condition | Select one of the options To add more conditions, hover your mouse pointer over this field to display the button. | | 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.
| | Insert excerpt |
|---|
| _delete |
|---|
| _delete |
|---|
| nopanel | true |
|---|
|
| Hover your mouse pointer over a filter clause to display this button.
Delete the selected clause or condition from the filter. | | Insert excerpt |
|---|
| _filter_literal |
|---|
| _filter_literal |
|---|
| nopanel | true |
|---|
|
| 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 the value entered is an expression. Click this icon to treat the value to a literal string. | | 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_ticked |
|---|
| _check_box_ticked |
|---|
| 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. |
|