Identity Manager 8.1.4 - Target System Synchronization Reference Guide

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 2: 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.