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