The Query Condition dialog box
is part of the Custom Query Builder and can be used to add conditions
to filter the query results.
To add a query condition:
In the Custom
Query Builder, on the Filters
tab, click Add Condition.
Choose a field.
Choose a comparison operator.
Enter a value or formula
in the text box to use as the filter criteria.
For example, to query for all active accounts: select the account
data object, the active field,
the = operator, and type Y in the text box.
Note: Always use double quotes around character data in the query
builder.
If you want to insert variables into the query:
Click Variables. The Variables dialog box appears.
Choose system variables or user variables, or create new user variables.
For example, to select all records that have changed since
the last time the process was run use the system variable :LastRunDateTime with
a source-modified date/time .
Optionally, use the Function
Browser to find an available function. Click Insert
Function in Expression to add the function.