nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

In Clause in BIRT 3.7

Max_Reeds

Hello All, 
 
Sorry for asking the same question again. I am using BIRT 3.7 and got stuck with passing multiple values to an SQL IN clause (Eg. Select * from abc where xyz in ?). 
 
I did find a link in this forum 
 
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/20721-in-clause-and-birt-functions-lib/page__pid__69414__st__0&#entry69414__s__353d3cf102cd48d99326bfdd230fb59a'>In Clause Birt Forum</a> 
 
I did try to resolve the problem using this solution (also found in BIRT forum posted in 2008) 
 
<a class='bbc_url' href='http://fahadzia.wordpress.com/2008/08/30/using-inlike-clause-in-birt/'>In Clause Solution</a> 
 
I just wanted to know if this has been addressed in BIRT 3.7 as it is a very common requirement and people are struggling with this (as far as I have searched for the solution). 
 
Kindly do let me know of a clean way of doing it in BIRT 3.7. 
 
Waiting for a favorable reply. 
 
Kind Regards. 
Max Reeds.

Find more posts tagged with

Comments

mwilliams

Hi Max,

You'll have to do this in the beforeOpen script still. There are a few different solutions offered in the devShare on how to do this. One is to put a marker in your query, like "xx" rather than the '?', so you'd have:

Select * from abc where xyz in ('xx')

Then, in your beforeOpen, you'd join the values of the parameter object, separated by ',' and run a replace on your queryText to replace xx with this comma separated string.

Max_Reeds

Hello Michael,

Thank you so much for the response.

"There are a few different solutions offered in the devShare on how to do this"

Could you kindly point out to those solutions as we are very near to dropping BIRT from our project and moving on to other options such as Jasper Reports.

Waiting for a favorable reply.

Kind Regards.
Max Reeds

mwilliams

Here's the one I specifically mentioned:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/

Here are some others:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/688-using-a-multivalue-parameter-in-an-in-clause/

http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html

Max_Reeds

Hello Michael.

Thank you so much for the links. Really appreciated your help. Will have look at the other two links you gave.

Kind Regards.
Max Reeds.

mwilliams

Not a problem at all. Let me know if you run into issues. Good luck.