Conditions Tab
This tab allows you to specify the conditions that will be used in the SQL query.
The tab contains the conditions list with two columns:
- Condition — A simple condition. For example, [PERMISSION] = ~ACC::%PERMISSION%~.
- Match case — Contains Yes if the condition comparison is case-sensitive, and No otherwise.
| Option | Description |
|---|---|
| Add | Click this button to add a new condition to the list. This button opens the Condition dialog box. |
| Edit | Select a condition and click this button to edit the selected condition in the Condition dialog box. |
| Remove | Select a condition and click this button to remove the selected condition from the list. |
| ALL | If this option is selected, the SQL query will return only the records that satisfy all the specified conditions. |
| ANY | If this option is selected, the SQL query will return the records that satisfy at least one of the specified conditions. |