The wizard helps you to formulate a condition (where clause) for database queries. The complete database query is composed internally. It always refers to the database table that is specified when you start the wizard.
Figure 21: Wizard for entering database queries
There are predefined operators to make it easier to create conditions. The operators are underlined. Operators with a help entry for the permitted value (such as column selection, data input or free text) are shown in parentheses (<<Operator>>).
To create a database query using the wizard:
Click to select the desired item and confirm using the button.
- OR -
Double-click the desired entry.
The preview shows all the entries that meet the defined condition.
The database query condition is shown in SQL syntax.
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 enter database queries directly or put them together with a wizard. Use and to switch to the appropriate view.
You can use variables in your condition definitions. Variable must be masked.
NOTE: If the condition contains a dollar sign, which is not labeling a variable, it must be masked with $.
Example: '300 $$' compared to the value '300 $'
|TIP: If you enter a condition directly, you can access predefined variables with the button.|
Each condition is displayed in a special control in the wizard. The controls contain connection points to logically join single conditions or delete single conditions. The connection points are set if you mouse over the edge of the respective control.
Figure 22: Wizard for Entering Filters
To create a filter with a wizard
This inserts a control for the first condition.
The properties for filtering are listed. You can also define other properties and use variables.
Use the comparison operators =, <>, <, >, <=, >= and like to define conditions.
You can enter a string for a comparison value or select a property from the list. You can also use variables.
||NOTE: To be able to switch to this input field at a later date, choose Input field from the list.|
The connection points appear.
This adds a new control for the next condition.
||Note:To remove a control, select the connection point, Delete.|
Use the selection list to select an element.
Note: You can add to some selection lists, in which case an entry selection appears in the list.
The extended selection list links to elements from a different database table. To better display your hierarchical structures, from this selection list you can select from hierarchy trees as well as flat structures.
Figure 23: Extended selection list
To select a value form an extended selection list
- OR -
Double-click the entry to enable or disable it.
The selection list closes automatically.
Tip: As you enter text in the input field, the system filters the selection data for you. When you open the selection list you can see the entries that contain the text you entered. If the entered text is clear, you can also select the entry with the Tab key.
To search in the selection list
Some foreign key relationships are identified dynamically in One Identity Manager. There are two steps to selecting a dynamic foreign key.
Figure 24: Selecting dynamic entries
To specify a dynamic entry:
Click next to the text box.