List with Several Values (IN)
You can define a list of several search values for the same search item. For example, if you want to state several accounts that should be summarized. Use the sign # as demarcation between each value.
Example:
Search should be done for accounts 3500, 3510 and account 3540.
Search object | Search value accourding to SQL Smart syntax | Resulting SQL |
|---|---|---|
ACCOUNT | 3500#3510#3540 | ACCOUNT in ('3500','3510','3540') |