Skip to Content
Dec 28, 2018 at 09:21 AM

How to pass global variable using 'in' operator in query transform to filter records.


Hi experts,

I have requirement where I have to set filter globally using global variable to filter records-

for eg- I have variable $GV_Filter and I have set of records xx,yy,zz this may be change during run time it may come as aa,bb,cc. So my question is how i can use it in query transform to filter because I have tried 'IN' operator and passed the global variable there but it did not work and I don't want to use pushdown_sql as well. Any alternatives please let me know.