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

[former_member215091]

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

[former_member187605 · Accepted solution]

There's no reason why for not using pushdown_sql. That's your only option.

See this very recent discussion for the solution:

https://answers.sap.com/questions/706049/pushdown-a-global-variable-in-where-clause-using-i.html

[former_member215091 · Accepted solution]

Thanks Dirk for your quick response. but for some reason business don't want to use some extra process by using pushdown_sql.

[former_member187605]

Not to my knowledge.

[former_member187605]

You didn't mention your source is ECC.

Because pushdown_sql can only be used with database datastores...

[former_member215091]

Yes. any other option?

[former_member187605]

Pushdown_sql doesn't generate any "extra process" at all. It only modifies the SQL code that is generated by DS at runtime.

[former_member215091]

Thanks Dirk Venken and Happy New Year. Extra process in the sense we are filtering data from SAP system and pushdown_sql gives error when directly applying.to SAP DS along with other filter so we have to add another data flow for filter where we will use pushdown_sql. That is the extra process what I meant.