Page Comparison

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

...

To create a filter, add conditions and clauses.

...

Field

Description

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
nopanel	true

button.

Insert excerpt

	_add
	_add
nopanel	true

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.

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.

Versions Compared

Old Version 6

New Version 7

Key