Multiple Independent Values (OR)
This function can be used to combine several search values. For example, you can combine an interval with multiple individual values. Use the character semicolon ; as the divider between values.
Example:
Search all accounts in the interval 3000-3099, and accounts 3200 and 3650.
Search object |
Search value accourding to SQL Smart syntax |
Resulting SQL |
|---|---|---|
ACCOUNT |
3000..3099;3200#3650 |
ACCOUNT between '3000' and '3099' or ACCOUNT in('3200','3650') |