Skip to Content
Jun 27, 2016 at 04:20 PM

Input parameter with multiple value in calculation view with expression.


My requirement is to create input parameter in calculation view where this input parameter can accept single value, multiple value and * for all as input.

created this by following step of this blog

Using Multiple Values in Input parameter for filtering in Graphical Calculation View

it is working perfect for single value and all value (*) but not working for multiple value as input.

provided input value as INR'',''USD ('' and two single ' )

tried so many way to input but when check to log then come to know that query is generating wrong ('PLACEHOLDER'=('$$IP_WAERK$$','INR\''\'',\''\''USD')) why this \''\ is added with query. changed query in sql editor to test like ('PLACEHOLDER'=('$$IP_WAERK$$','INR\'',''USD')) then it working perfect.

please let me know why this extra \''\ is adding with query.

😕 😕 😕 😕 😕 😕


Capture1.PNG (5.0 kB)