Compound Conditions (AND)
Function:
You can search for several items in a search value by using parentheses as demarcation between the different items.
Example:
Search all accounts in the range 3000-3099 for units 100 and 125.
Search object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3000..3099(UNIT:100#125) | ACCOUNT between '3000' and '3099' and UNIT in('100','125') |