Overcome SQL IN clause limit
Hello!
We have some reports to show subscription data and optionally we would like to filter by customer account.
We can add a parameter in the Data Model with a list of values to do this filter, but if we use an IN clause, we will reach the limit of 1000 values and the report will break.
I saw alternatives on the internet with temporary tables or a select clause with the list (for example, SELECT * FROM TABLE(SYS.ODCIVARCHAR2LIST(:CUSTOMER_LIST)), but I couldn't make it work using the parameter. In the case of the example above, due to the same limitation of 1000 values.