Problem
You have a multiselect field and you require want to write an IN clause using that a specific multiselect field into the SQL statement configured on the Database Custom Fields (DBCF) field.
Solution
...
| Note |
|---|
The following This solution applies to Oracle only, but equivalents can be found in used on any decent database. |
Unfortunately, the IN clause is not fully treated in DBCF. It would mean that we should parse the query and replace the keywords with the real IN values, something we found to be difficult to implement. But there's an alternative to that, and this is easy to address.
...