Query Builder Adding Criteria

<< Click to Display Table of Contents >>

SmartConnect 2017

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).


 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.