Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Filter a table

Log in to subscribe to topics and get notified when content changes.

Filter a table

You can use the Filter table operation to search a source table for a specified value. If found, values are logged in a specified target table.


  1. Select Filter table from the Operation list in one of the following locations:
    • the Identification Sections or Connectivity Sections for Service Mapping
    • the Step window for Discovery
  2. Fill in the fields, as appropriate.
    Field Description
    Source table Name of source table to be searched.

    Use drag-and-drop or auto-complete to copy table names, fields, and values from the Temporary Variables and CI Attributes tables.

    Target table Name of target table to contain the values that were found.
    Condition builder Specify the criteria for determining which values from the Source table are placed in the Target table:
    1. Enter the table name and the column from which the values are retrieved. You can also use variables including values from tabular variables as described in Useful shortcuts in Pattern Designer.
    2. Choose the relevant operator.
    3. Enter the string that Pattern Designer uses to filter values.
    4. If necessary, add more criteria lines by clicking the plus icon (+).
    The condition fields for the filter table operation
    Note: If the specified target table is already populated, the new fields and values from the source table overwrite the existing fields and values of the target table.


The following configuration is an example of the Filter table operation.
Field Value
Hierarchy Applications > Application Servers
CI Type WebSphere EAR
Pattern J2EE EAR On Linux
Section DB2 JDBC connectivity
Step number and Name 8. Filter DB2 JDBCProviders