Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Field
Description
Condition

Select one of the options

  • Where ALL...
  • Where ANY...

To add more conditions, click 

Insert excerpt
_new
_new
nopaneltrue
 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
    nopaneltrue
     to delete the selected clause or condition from the filter.
  • Insert excerpt
    _filter_literal
    _filter_literal
    nopaneltrue
     indicates the value entered is a literal value. Click this icon to treat the value as an expression.
  • Insert excerpt
    _filter_expression
    _filter_expression
    nopaneltrue
     indicates the value entered is an expression. Click this icon to treat the value to a literal string.
  • Insert excerpt
    _editor_expand
    _editor_expand
    nopaneltrue
     to open a larger editor to enter a value or expression.
Ignore Case   

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 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
nopaneltrue
 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.


Insert excerpt
_description
_description

Insert excerpt
_property_tabs
_property_tabs
namesecurity-h
nopaneltrue

Insert excerpt
_access
_access

Insert excerpt
_property_tabs
_property_tabs
nameaudit-h
nopaneltrue

Insert excerpt
_access
_access
nopaneltrue