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: 4
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 (?))

Attachment: Capture1.PNG
(Size: 18.45KB, Downloaded 303 times)

[Updated on: Mon, 31 July 2017 13:31]

Report message to a moderator

Re: How to Pass multiple values to SQL query of IN operator through BIRT REPORT params? [message #1790946 is a reply to message #1769428]

Wed, 20 June 2018 12:53

jason us

Messages: 1
Registered: June 2018

Junior Member

On the property binding page add the sql - it will replace the sql from your query.
It's kind of a mess. You have to create the set with parens and include the single quotes around your dynamic params.

Select fieldname from table where whatever in "(" + "'"+params["param1"]"', ' " + params["param2"] + "'

It should be noted their is no way to do this dynamically for a multi-value parameter. Really pretty stupid this is missing. BIRT will even warn you that it won't work. if you hook a multi-valued param into the query.

I am still holding out that I can use javascript to parse the multi-value param which looks like this from a combo box [VAL1, VAL2]. I want to swap the brackets for parans and add single quotes around the values.

Report message to a moderator

Previous Topic:	Repeat Template Content
Next Topic:	Calculates between datasets. Horizontal format

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 19 22:15:28 GMT 2018

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter