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') |