At certain points you can define custom filter conditions. The filter conditions are formulated like a condition (WHERE clause) for a database query.
You can use a wizard to collect the queries. Each condition is displayed in a special control in the wizard.
The wizard is available in different places in the Web Portal, for example, in the People view.
|
NOTE: This function is not available on mobile devices. |
To open the filter wizard
To create a filter with the wizard, first select a column, edit the conditions and comparison operators. Once these settings have been configured, you can apply the filter.
To create and apply a filter with the wizard
The following views are available.
View |
Description |
---|---|
Value comparison |
Compares the values of the selected columns. These columns are part of the table you want to apply the custom filter to. The advantage of using the where clause wizard is that you can select all the table's columns as opposed to the filter function, which only provides a default selection of columns. |
References to other objects |
Creates a n:1 relation. Select the desired table B in this view. Several data records from table A can be assigned to one data record in table B. A data record in table A cannot be assigned more than one data record from table B. |
References for assignment tables |
Creates a 1:n relation. Each data record in table A can be assigned to several data records from table B and vice versa. These relations are realized through a third Table for realizing assignment tables Assignment table only contains the foreign keys of the other tables A and B. |
References of other objects |
Creates a 1:n relation. Select the desired table B in this view. Several data records from table B can be assigned to one data record in table A. A data record in table B cannot be assigned more than one data record from table A. |
Select Select the desired column in the Filter wizard view.
This inserts a control for the first condition.
Figure 1: Filter Wizard with Examples of Conditions
You can enter a date, numeric or text value. The type of value depends on the column.
To change the comparison operator, click on the comparison operator "is less than", for example.
The type of comparison operator depends on the column type. The following comparison operators are available.
Value Type |
Operator |
Description |
---|---|---|
Text |
equals |
Searches for the same text string. |
precedes the word in the alphabet |
Searches for all results that precede the given text alphabetically. | |
follows the word in the alphabet |
Searches for all results that follow the given text alphabetically. | |
not equal |
Searches for all results that do not correspond to the text. | |
is contained in |
Searches for all results that contain the text. | |
contains |
Searches for all results that contain the text. | |
starts with |
Search for all results that begin with the given text. | |
ends with |
Search for all results that end with the given text. | |
is equal or precedes the word in the alphabet |
Searches for all results that either contain the given text or precede it alphabetically. | |
is equal or follows the word in the alphabet |
Searches for all results that either contain the given text or follow it alphabetically. | |
Numeric |
is less than |
Searches for all results that are less that given number. |
is greater than |
Searches for all results that are greater than the given number. | |
equals |
Searches for all results that are equal to the given value. | |
is less or equal |
Searches for all results that are less than or the equal to the given number. | |
is greater or equal |
Searches for all results that are greater or equal to the given number. | |
not equal |
Searches for all results that do not match the given number. |
The value is False by default. If you change the value to true, data appears that matches the content of this column.
The condition statement is reversed and the data displayed after filtering, does not match this condition. This setting is not available if the Boolean option can be set.
|
NOTE: Remove the control by clicking |
Perform one of the following tasks.
This returns you to the original view where a message alerts you to the active filter wizard.
The filter wizard view can quickly become confusing if several conditions are used with different controls. In this case, you can expand or collapse the conditions with your controls.
To expand or collapse controls.
If you want to view the technical names of a database column instead of the display names, you can change the display settings.
To display technical names of database columns
This displays all the table and column names that occur in the filter wizard with their technical names.
© 2021 One Identity LLC. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy