SmartConnect 2018
Query Builder Adding Criteria
To define criteria for the expression listed in the Query Columns area the Criteria column should be used.
In the criteria column enter the criterion (omitting the expression).
i.e.
To enter a criteria of WHERE (field >= 10) AND (field <= 20)
>= 10 AND <= 20 should be entered.
Multiple criteria for a single expression may be used using the 'Or' operator.