Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how to use dynamic arguments for in clause for sql for datawindow?

I have datawindow with sql like:

select c1, c2, ... from mytab where id = :arg1.

id is integer.

Then I want to change the query like:

select c1, c2, ... from mytab where id  in ( 1, 2, 3)

the number of ID value is dynamic, could be any. in pb code, I can get the string like '1,2,3', but how to set argument for datawindw datassource for this case?

Former Member
Former Member replied

Could you change your datawindow retrieval argument type from 'number' to 'number array', and change '=' to 'IN'?

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question