Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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)
How to Pass multiple values to SQL query of IN operator through BIRT REPORT params? [message #1769428] Mon, 31 July 2017 13:24 Go to next message
epn 898 is currently offline epn 898Friend
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 Go to previous message
jason us is currently offline jason usFriend
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.
Previous Topic:Repeat Template Content
Next Topic:Calculates between datasets. Horizontal format
Goto Forum:
  


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

Powered by FUDForum. Page generated in 0.02236 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top