Skip to main content
OnCommand Workflow Automation 5.0
A newer release of this product is available.

Create a filter


You can create a WFA filter that can search for resources if there is no predefined WFA filter that is suitable for the task.

What you'll need

You must know the appropriate SQL syntaxes to create the filter.

  1. Click Designer > Filters.

  2. Click New icon on the toolbar.

  3. In the Properties tab of the New Filter dialog box, enter or select the required details in the Name, Dictionary type, and Description fields.

  4. In the Query tab, enter the appropriate SQL query for the filter.

    You must enter a single SQL query and optionally use input parameters. You should use the following syntax to use an input parameter: ${ParameterName}.

    WHERE = '${ArrayName}'
  5. Click Refresh to populate the Input Parameters table and the Returned Attributes list.

    This information is obtained from the SQL query that you have entered. For example, if you use the SQL query example from the previous step, ip is displayed in Returned Attributes and ArrayName is displayed in Input Parameters. You can edit the entries in the Label and Description columns.

  6. Optional: Click Test to test the filter.

    1. In the Test Filter <FilterName> dialog box, enter the required test parameters.

    2. Clear the Use reservation data in test check box if you do not want to use the reservation data for testing the filter.

    3. Click Test.

      The test result is displayed.

    4. Close the dialog boxes.

  7. Click Save.