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.

SmartConnect_QueryBuilder_Criteria