Using Condition Parameters
To use a condition parameter:
- Open Query Builder. See Opening Query Builder
- In the Query Builder window, click the Conditions tab.
-
Select a table from the upper left side of the Query Builder.
If necessary, click the plus sign to expand the list of tables.
- Select a date/time, string, or integer field.
- Select an Operator. See Query Builder Statement Operators
- Select Use Value as a Literal.
-
Click in the Value is box, click
the drop-down arrow and select an item from the list.
Note: Parameter options are only available for specific field types and operators. See the tables for the options available for field types and operators. See Condition Parameters
- If you selected a parameter with an "x" placeholder value, the Provide Template Value dialog box opens. In the box, type a numeric value to replace the "x" placeholder value.
- Click OK.