Operators - Unity Client - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Unity Client

Platform
OnBase
Product
Unity Client
Release
Foundation 23.1
License
Standard
Essential
Premier

Column filter operators are used to define how to apply a filter to a data list with regard to the value specified in the column's filter drop-down list.

Operators are available by clicking the operator button:

Depending on the type of value the column contains, the following operators may be available:

Operator

Description

Equals

Values equal to the value specified in the corresponding drop-down list are displayed.

Not equals

Values not equal to the value specified in the corresponding drop-down list are displayed.

Less than

Values less than the value specified in the corresponding drop-down list are displayed.

Less than or equal to

Values less than or equal to the value specified in the corresponding drop-down list are displayed.

Greater than

Values greater than the value specified in the corresponding drop-down list are displayed.

Greater than or equal to

Values greater than or equal to the value specified in the corresponding drop-down list are displayed.

Contains

Any values containing the value specified in the corresponding drop-down list are displayed.

Does Not Contain

Any values containing the value specified in the corresponding drop-down list are not displayed.

Top

The top number of values specified in the corresponding drop-down list are displayed.

For example, when Top is selected and 2 is entered in the ID column drop-down list in the Users layout, the two most recently created users are displayed.

Bottom

The bottom number of values specified in the corresponding drop-down list are displayed.

For example, when Bottom is selected and 2 is entered in the ID column drop-down list in the Users layout, the two users created first (ADMINISTRATOR and MANAGER) are displayed.

Top percentile

Values in the top percentile of the value specified in the corresponding drop-down list are displayed.

Bottom percentile

Values in the bottom percentile of the value specified in the corresponding drop-down list are displayed.

Like (wildcards)

Values like (including wildcards) the value specified in the corresponding drop-down list are displayed.

Not like (wildcards)

Values that are not like the value (including wildcards) specified in the corresponding drop-down list are displayed.

Match (regular expression)

Values that match (including regular expression) the value specified in the corresponding drop-down list are displayed.

For example, typing A*M in the Name column in the Users layout displays the MANAGER and ADMINISTRATOR user names, because both user names contain the letters A and M.

Does not match (regular expression)

Values that do not match (including regular expression) the value specified in the corresponding drop-down list are displayed.

Starts with

Values that start with the value specified in the corresponding drop-down list are displayed.

Does not start with

Values that do not start with the value specified in the corresponding drop-down list are displayed.

Ends with

Values that end with the value specified in the corresponding drop-down list are displayed.

Does not end with

Values that do not end with the value specified in the corresponding drop-down list are displayed.

In

This option is intended for use with Reporting Dashboards. For more information, see the Reporting Dashboards module reference guide.

Not In

This option is intended for use with Reporting Dashboards. For more information, see the Reporting Dashboards module reference guide.