Overview
Use filters to display or work with a subset of data in a stream.
...
| Condition | Select one of the options To add more conditions, click button. |
| 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 |
|---|
|
to 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.| 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. |
| Insert excerpt |
|---|
| _description |
|---|
| _description |
|---|
| nopanel | true |
|---|
|
...