Home › Discussions › Questions & Answers › Troubleshooting Multiple Values feature availability
Customer · · Questions & Answers · 7 replies
I have created a new parameter, but the ‘Multiple Values’ checkbox is unavailable. What conditions must be met for Blitz Report to automatically replace the SQL restriction with an IN-clause?
Automated IN-clause replacement is disabled if the parameter SQL text is too complex, or if it uses an unsupported operator (like `>=` or `<`). It requires a simple restriction using `=`, “, `!=`, `like`, or `not like` operators.
Does the order matter within the SQL restriction?
Yes, the order is critical. For the feature to work, it is required to have the table column on the left and the :bind variable on the right side of the comparison operator. A SQL text such as `:bind_variable=column_name` will not work.
And what about the type of anchor used?
The multiple values functionality is only available for parameters with anchor styles 1=1 or &lexical. It is not available for parameters using :bind anchors.
If I use a function like `upper(column_name) like upper(:bind_variable)`, will that prevent the IN-clause replacement?
No, you can successfully use functions like `upper(column_name) like upper(:bind_variable)` and the replacement will still work, provided the other conditions are met.
Sign in with LinkedIn or Google to take part.
