How to pass values to custom query parameters using data on demand

[praveen patil 3]

Hi All

i have connected custom query parameters to data on demand setting but when i pass values, parameters are not replaced with actual values in query so query is not returning any data.

values are coming like this

contract_id in (:p1,:p2,:p3,:p4)

please help on this.

 

Thanks,

Praveen

[Shashank Gurnalkar]

Can you try this

select * from table_name where column_namein (p1,p2)Make sure to define p1 and p2 in the parameters tab.