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

Filter a table

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 feature to copy table names, fields, and values from the Temporary Variables and CI Attributes tables.

    Target table Name of target table to contain values 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 taken.
    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