Adding a filter to a query

Use this procedure to create a filter for a query. When you create filters, you can filter against specific values or you can use parameters to prompt for the values at the time the query is executed.

To add a filter to a query

  1. On Query Buidler, define the basic query.
  2. In the Properties view of the right pane, click Filter or right-click on the query diagram and select Define Filter.

    The Filter Setup window is displayed.

    Form clip: Filter Setup window
  3. Define the filter by selecting items from the left pane or by specifying values directly into the right pane. If you double-click an item in the left pane, it is placed in the right pane. Enclose literal values in double quotes. Ensure that the "AND" and "OR" logical conjunctions are surrounded with spaces.
  4. To include parameters for the filter, that is, fields that allow you to prompt for values, specify them in using the parameter syntax. See Replaceable parameters in command strings.
  5. When you are finished, close the Filter window. The filter is shown as part of the query properties and query string.
  6. Click Execute to test the query.