Identity Manager 8.0 - User Guide for the User Interface and Default Functions

Wizard for entering database queries

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:

1. Start the wizard by pressing .
2. Create the database query.
   • When you hover over an operator, the cursor changes to a hand symbol.
   • If an operator has only two permitted values you can click to switch between the values.
   • Click an operator with more than two permitted values to open a selection list showing the operator's permitted values.

     Click to select the desired item and confirm using the button.

     - OR -

     Double-click the desired entry.

   • A selection window opens in which you can select all database columns of the base object and its related objects. Use SQL name to switch between the display name and the technical name of tables and columns.
   • For complex database queries, you have the option of linking several conditions together. After each condition there is a row showing the logical operator for the connection, followed by another row for the next condition. Use the button in front of a condition to delete it from the query.
   • Press Expert view if you wish to enter the query yourself in SQL format. Click Wizard view to switch back to the simple input mode.
3. click Next.

   The preview shows all the entries that meet the defined condition.

4. click Next.

   The database query condition is shown in SQL syntax.

5. Click Finished.

Entering Custom Filter Conditions

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.

• The comparison operators =, <>, <, >, <=, >= and like are supported for defining conditions.
• To link condition you can use the logical operators AND, OR and NOT.

• You can use variables in your condition definitions. Variable must be masked.

  Syntax: '$<variable>$'

  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

1. Click Create condition.

   This inserts a control for the first condition.

2. Enter the condition.
   1. Click the left-hand part of the condition and select the property to filter by.

      The properties for filtering are listed. You can also define other properties and use variables.

   2. Specify the comparison operator. Click the comparison operator to change it.

      Use the comparison operators =, <>, <, >, <=, >= and like to define conditions.

   3. Specify the comparison value on the right-hand side of the condition.

      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.

3. To link condition you can use the logical operators AND, OR and NOT.
   1. Mouse over the edge of the control to which you wish to create a link.

      The connection points appear.

   2. Mouse over a connection point and select the connection.

      This adds a new control for the next condition.

   Note:To remove a control, select the connection point, Delete.

Selecting from Lists

Use the selection list to select an element.

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

1. Open the selection list by clicking the arrow.
2. Click the entry once to enable or disable it, then close the selection list.

   - OR -

   Double-click the entry to enable or disable it.

   The selection list closes automatically.

To search in the selection list

1. Click the magnifying glass in the selection list title bar to open the search dialog.
2. Enter your search term.
3. Set the option Case sensitive if required.
4. Start the search with Search or Enter.
5. Use F3 to continue searching.
6. End the search with Esc.

Selecting a Dynamic Entry

Some foreign key relationships are identified dynamically in One Identity Manager. There are two steps to selecting a dynamic foreign key.

1. Specify the table in which the object should be identified.
2. Select the actual object.

Figure 24: Selecting dynamic entries

To specify a dynamic entry:

1. Click next to the text box.

2. Under Table, select in the table in which to identify the object.
3. Select the actual object from the next list.
4. Click OK.