1. Asset Liability Management Cloud User Guide
  2. Business Rules Administration
  3. Common Rules
  4. Filters
  5. Creating Filter Definitions
  6. Defining a Data Element Filter
  7. Creating Another Element Filter

4.2.3.3.2.3 Creating Another Element Filter

You can match a selected database column to another database column.

When creating an Another Data Element Filter Method, you may only compare a column to other columns that you have already selected (the Data Element drop-down list box will only contain columns that you have already selected).

.
To create an Another Element filter, proceed with the following steps, after selecting the Database table name, column name and the Data element.
  1. Select Another Element in the Filter Methods.
  2. Select a Table Column, that needs to be compared with the Data Element Column.
  3. Select one of the following mathematical operators for comparison.
    • = - Equal to
    • <> = Not equal to
    • < - Lesser than
    • > - Greater than
    • <= - Lesser than or equal to
    • >= - Greater than or equal to
  4. Select a Data Element, that needs to be compared with the Table Column.
  5. Click Add to add the expression to the filter condition.
    To edit an existing Another Element Filter entry, select the entry listed in the Filter Condition pane. Modify the expression in the Another Element Pane and click Update.