Versions Compared

Old Version 6

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version Current

changes.mady.by.user Zoe Baldwin

Saved on

Key

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

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

Insert excerpt
_Banners
_Banners
namefilersort
nopaneltrue

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:

  1. In  the repository, expand the

...

  1. table.
  2. Right-click on Filters and 
    Insert excerpt
    _

...

  1. new
    _

...

  1. new
    nopaneltrue
      a new filter.

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

...

table:

  1. In  the repository, expand the

...

  1. table.
  2. Expand the data view.
  3. Right-click on Filters and 
    Insert excerpt
    _

...

  1. new
    _

...

  1. new
    nopaneltrue
      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
nopaneltrue


Insert excerpt
_property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
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

...

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

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

During Import

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 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
nopaneltrue
 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
titleMore ...

Insert excerpt
_protect_import
_protect_import
nopaneltrue


Include History Records

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 to include superseded records in the filtered records

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to automatically filter out superseded records.

Filter Details

To create a filter, add conditions and clauses.

...


Field
Description
Condition

Select one of the options

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

To add more conditions,

...

click 

Insert excerpt
_

...

new
_

...

new
nopaneltrue
 button.

...

Hover your mouse pointer over the Condition field to display this button.
Add another condition to your filter.

...

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
    nopaneltrue

...

  •  to 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

...

  •  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
    nopaneltrue

...

  •  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_tick
_check_box_tick
nopaneltrue
 so that the condition only matches strings that have the same capitalisation (case-sensitive).

Insert excerpt
_check_box_

...

untick
_check_box_

...

untick
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 Attribute

Insert excerpt
_property_settings
_property_settings
nopaneltrue
 → Advanced section → Filter conditions are case-

...

sensitive by default.

...

Insert excerpt
Attribute
Attribute
namecaseSensitiveDatabase
nopaneltrue


Insert excerpt
_description
_description
nopaneltrue

Insert excerpt
_access
_access
nopaneltrue





Live Search
spaceKey@self
additionalnone
placeholderSearch all help pages
typepage

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel3
indent12px
stylenone

  Learn More

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

Insert excerpt
_terms_changing
_terms_changing
nopaneltrue