Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
This page is for data modellers or application developers who need to filter the data that is displayed in tables.
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.Insert excerpt _new _new nopanel true
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.Insert excerpt _new _new nopanel true
PhixFlow displays the filter properties.
You can also apply filters on the data directly in a dashboard or view; see Filters on Data Views.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Basic Settings
Field | Description | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Name | Enter the name of the filter. | ||||||||||||||||
Private | Available to users with the Create Public Filters privilege. Image Modified 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. Image Modified Untick to make the filter available to other PhixFlow users. | ||||||||||||||||
Protect During Import |
|
...
parent table is deleted by the import, its filters are also deleted.
| |||||||||||||
Include History Records |
...
|
Filter Details
To create a filter, add conditions and clauses.
Field | Description | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Condition | Select one of the options
To add more conditions, click
| ||||||||||||||||||||||||||||||||
Clause line | For each part of the clause line, select an option from the list. PhixFlow adds more fields where you can:
Click the icons:
| ||||||||||||||||||||||||||||||||
Ignore Case |
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 MariaDB (MySQL) databases. For PhixFlow instances running on a SQLServer database, filters are always case-independent. |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||
---|---|---|
|
...
|
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
For links to all pages in this topic, see Designing Screens.
Insert excerpt | ||
---|---|---|
|
...
|
...
|