Insert excerpt

	_Banners
	_Banners
name	filersort
nopanel	true

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
Insert excerpt
_new
_new
nopanel true
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
Insert excerpt
_new
_new
nopanel true
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.

Insert excerpt

	_standard_settings
	_standard_settings
nopanel	true

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Insert excerpt

	_parent
	_parent
nopanel	true

Basic Settings

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

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

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.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

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.

Expand

title	More ...

Insert excerpt

	_protect_import
	_protect_import
nopanel	true

Include History Records

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to include superseded records in the filtered records

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to automatically filter out superseded records.

Filter Details

To create a filter, add conditions and clauses.

Ignore Case

Field

Description

Condition

Select one of the options

Where ALL...
Where ANY...

To add more conditions, click

Insert excerpt

	_new
	_new
nopanel	true

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
nopanel true
to 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 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.
Image Added
Insert excerpt
_editor_expand
_editor_expand
nopanel true
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 databases.

Insert excerpt

	_check_box_

untick

tick
	_check_box_

untick

tick
nopanel	true

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

Insert excerpt

	_check_box_

tick

untick
	_check_box_

tick

untick
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 attribute property tab →underlying Attribute

Insert excerpt

	_property_settings
	_property_settings
nopanel	true

→ Advanced section → Filter conditions are case-independent sensitive 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

	Attribute
	Attribute
name	caseSensitiveDatabase
nopanel	true

Insert excerpt

	_description
	_description
nopanel	true

Insert excerpt

	_access
	_access
nopanel	true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page

Panel

borderColor	#00374F
titleColor	white
titleBGColor	#00374F
borderStyle	solid
title	Sections on this page

Table of Contents

maxLevel	3
indent	12px
style	none

Learn More

Table

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

Insert excerpt

	_terms_changing
	_terms_changing
nopanel	true

Versions Compared

Old Version 19

New Version Current

Key

Overview

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Basic Settings

Filter Details

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page

Page Comparison

Versions Compared

Old Version 19

New Version Current

Key

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Filter Details

Live SearchspaceKey@selfadditionalnoneplaceholderSearch all help pagestypepage

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page