Versions Compared

Old Version 1

changes.mady.by.user Ian Fitzgerald (Unlicensed)

Saved on

compared with

New Version 2

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

Key

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

A Filter allows you Use filters to display or work with a subset of data in a stream. To add a filter to the data in a stream:

  1. In  the repository, expand the stream.
  2. Right-click on Filters

...

Form: Filter

...

  1. and 
    Insert excerpt
    _add
    _add
    nopaneltrue
      a new filter.
  2. PhixFlow displays the filter properties.

You can also apply filters on the data that is displayed in a view; see Using Filters on Data Views.

Filter Properties

Insert excerpt
_standard_settings
_standard_settings
nopaneltrue

Basic Settings

FieldDescription
NameThe 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 import

 Tick to prevent the filter being updated or deleted during import.

 Untick to allow the filter to be updated or deleted during import.

Filter Details

...

Create a filter by adding conditions and clauses.


Field
Description
DescriptionOptional: a description of the macro.

Filter Details

Build a filter by adding conditions and clauses.

...

Field

...

Description

...

Image Removed Add

...

Add a clause to the filter. Hover over the editor to the right of a condition to see this button.

...

Image Removed Delete

...

Condition

Select one of the options

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

To add more conditions, hover your mouse pointer over this field to display the 

Insert excerpt
_add
_add
nopaneltrue
 button.

Insert excerpt
_add
_add
nopaneltrue

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
nopaneltrue

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
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.

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_ticked
_check_box_ticked
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.

...

Image Removed Filter Picker

...

See Also

...