Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Overview

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

...