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.
😕 😕 😕 😕 😕 😕