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

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

1244 Views

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.

Thanks,

Faiz