Eclipse Community Forums: BIRT » How to Pass multiple values to SQL query of IN operator through BIRT REPORT params?

Home » Eclipse Projects » BIRT » How to Pass multiple values to SQL query of IN operator through BIRT REPORT params?(Passing Multiple values to SQL query of IN operator)

Show: Today's Messages :: Show Polls :: Message Navigator

How to Pass multiple values to SQL query of IN operator through BIRT REPORT params? [message #1769428]

Mon, 31 July 2017 13:24

epn 898

Messages: 5
Registered: June 2017

Junior Member

If I pass one value it is working fine, When I try to send multiple values to IN operator I am not getting data.
index.php/fa/30203/0/

When I send single value ACCEPTED it is working, When I send like below manner it is not working. i tried in multiple ways like below :

ACCEPTED','DATADIFF
'ACCEPTED','DATADIFF'
"ACCEPTED','DATADIFF"
How can I send multiple values to in operator?(and a.ReasonCode in (?))