Chat now with support
Chat with Support

Identity Manager 8.1.4 - User Guide for One Identity Manager Tools User Interface

About this guide One Identity Manager tools user interface
The user interface layout Using the help in the Manager Status bar information Current user Menu items in the Manager Views in the Manager Manager program settings Reloading modifications to the user interface Detailed information about the user interface Limiting list entries using the list limit Limiting list sizes using simple filters Searching for list entries User-defined filters in the Manager Database search in the Manager Displaying advanced properties of an object Multiple object edit in the Manager Committing data on change conflicts
Working with the Designer

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, which is preset when the Where clause wizard starts.

NOTE: In contrast to the filter designer, the Where clause wizard can also be used for columns not displayed in Unified Namespace.

Figure 16: WHERE clause wizard

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 WHERE clause wizard

  1. Start the WHERE clause wizard by pressing the button.
  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 permissible values to open a menu listing the permissible operator values.

      Click to select the required entry and then use the button to confirm the selection.

      - OR -

      Double-click an entry to select the value.

    • 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.
    • Use the Expert view button to switch to direct entry of the query in SQL syntax. Use the Wizard view button to switch back to the simple input mode.
  3. Click Continue.

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

  4. Click Continue.

    The database query condition is shown in SQL syntax.

  5. Click Finished.

Filter designer

The filter designer helps you formulate a condition for database queries. The complete database query is composed internally. It always refers to the Employee.

Figure 17: Filter designer

To create a database query using the filter designer

  1. Start the wizard by pressing .

  2. Using the all operator, specify whether at least one or all of the conditions defined below must be fulfilled.

    • When you hover over the operator, the cursor changes to a hand symbol.

    • By clicking the operator, switch between the all and at least one values.

  3. Create the conditions.

    1. In the first menu, specify the condition type.

      Depending on the condition type, other menus are displayed.

      Table 25: Permitted condition types

      Condition Type

      Meaning

      Property

      Employee object properties. The drop-down menu with permitted properties is already restricted to the most important employee properties.

      For the account with the target system type

      Employee’s user account. Valid user account properties depend on which target system is selected.

      You can only select columns that are shown in the Unified Namespace and for which the Display in the filter designer option is enabled.

      For entitlements with the target system type

      Employee target system group. Valid group properties depend on which target system is selected.

      You can only select columns that are shown in the Unified Namespace and for which the Display in the filter designer option is enabled.

      SQL Query

      Free choice of SQL query (WHERE clause). To use the WHERE clause wizard, click .

    2. From the additional menus, select the object attributes for the condition.

      All other controls are operators and properties that you require to formulate the condition. You can only select one entry from the drop-down menu. You can select more entries from extended drop-down menus, where the properties are displayed hierarchically and then added to the condition using an "or" operator. You may enter text directly into input fields. Pop-up menus and input fields are shown and hidden dynamically.

    3. To insert another condition, click . All partial conditions are linked by an AND link.

    4. To delete a condition, click .

    5. To the preview window, click . All objects determined by the condition are displayed.

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 the and button to switch to the relevant 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 18: 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.

      The comparison operators =, <>, <, >, <=, >=, and like for defining conditions are supported.

    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 switch back to the input field again, select Input field from the menu.
  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 Delete connection point.

Selecting from lists

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 19: Extended selection list

To select a value form an extended selection list

  1. Open the selection list by clicking the arrow.
  2. Enable or disable an entry using a single click and close the menu.

    - OR -

    Enable or disable an entry by double-clicking.

    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 unique, you can also select the relevant entry using the tab.

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating