Overview

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

To add a filter to the data in a table:

In the repository, expand the table.
Right-click on Filters and
a new filter.

To add a filter to a view of the data in a table:

In the repository, expand the table.
Expand the data view.
Right-click on Filters and
a new filter.

PhixFlow displays the filter properties.

You can also apply filters on the data directly in a view on a screen; see Filters on Data Views.

Basic Settings

Field	Description

Field	Description
Name	Enter the 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	to allow the filter settings to be changed if this filter is imported from another PhixFlow instance. If the imported configuration does not include this filter, it will be deleted. to retain the filter settings if this filter is imported from another PhixFlow instance. To prevent orphaned filters, when a parent table is deleted by the import, its filters are also deleted.
Include History Records	to include superseded records in the filtered records to automatically filter out superseded records.

Filter Details

To create a filter, add conditions and clauses.

Field	Description

Field

Description

Condition

Select one of the options

Where ALL...
Where ANY...

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:

to delete the selected clause or condition from the filter.
indicates the value entered is a literal value. Click this icon to treat the value as an expression.
and a green border indicates the value entered is an expression, allowing autocomplete of fields and Functions. Click this icon to treat the value to a literal string.
to open a larger editor to enter a value or expression.

Case Sensitive

This field is only available for PhixFlow instances running on Oracle or MySQL.

so that, for PhixFlow instances running on Oracle or MySQL, the condition only matches strings that have the same capitalisation (case-sensitive).

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

For PhixFlow instances running on a SQLServer database, filters are always case-independent.

Search
Search all help pages

Sections on this page

Learn More

Table

For links to all pages in this topic, see Designing Screens.