Open topic with navigation

Tools: SQL Builder - Criteria

Use the Criteria tab to set the search condition used by SQL Buider for each selected field.


Figure1:Conditions Folder.


Attributes
:

Conditions - To set the search condition for a field, the user select the field (from a list of selected fields in the Fields folder) and select the operation:

Example: To search for records of customers born from 01/01/1970, select the Date of birth field, select the symbol >= and enter "01/01/1970".

Click in Confirm to move to next step : Execution folder or Saved folder.