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

Home » Archived » 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)

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

Mon, 31 July 2017 09:24

Eclipse User

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 2170 times)

[Updated on: Mon, 31 July 2017 09:31] by 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 08:53

Eclipse User

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.

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

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Mar 19 03:25:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter