BIRT Multi-Select Statements - Help to integrate

Hello, 
 
I'm new to BIRT and Eclipse Plugin development platform. 
 
BIRT 2.5, Eclipse 3.5. 
 
I would like to use the "IN" sql parameter in my SQL statements. I understand that BIRT does not contain native support for this kind query pattern. 
 
I found a solution here : <a class='bbc_url' href='http://birtworld.blogspot.com/2009/03/birt-multi-select-statements.html'>BIRT World: BIRT Multi-Select Statements</a> 
 
From this I learn that I need to add this plugin into my BIRT runtime- How do I do this? How do I take the complied files (produced by eclipse after I imported the plugin code as a project) and put them into BIRT so that the ReportEngine can work with the plugin. 
 
The code was downloaded from here: <a class='bbc_url' href='http://longlake.minnovent.com/repos/birt_example/com.innoventsolutions.birt.functions/'>birt_example - Revision 448: /com.innoventsolutions.birt.functions</a> 
 
I would appreciate an explanation. 
 
 
Thank you, 
Maxim.

Find more posts tagged with

Comments

hq4ever

Alternatively, is there a different approach to integration the "IN" support or simply replacing it with a different solution - My requirement is receiving multiple selection from the user and based on this input generating SQL that would retrieve the object-keys that were supplied by the user.

Again, thank you.

Virgil Dodson

Hi Maxim, 
 
Searching for "clause" in the DevShare on BIRT-Exchange shows several examples. Here is a direct link: <a class='bbc_url' href='http://www.birt-exchange.org/devshare/?filtercontent=clause&contenttype=-1&date=-2year&rating=0&results=10&cid=0'>All Topics - BIRT Exchange</a>

scottr

Maxim,

Once you have the code in your environment, you need to build it as a plugin jar file. The easiest way to do this is to open the plugin.xml. On the plugin.xml Overview tab in the right column towards the bottom you will see an "Export Wizard" option.

Click on this option and it will bring up a dialog, you need to specify where you want the plugin jar file built to. You want to give it your ECLIPSE_HOME directory, do not add plugins it will be added automatically.

e.g. on my machine eclipse is installed to c:javaeclipse, that is the directory I export to.

Once you have done this, restart Eclipse and now you should see the function available in the script editor and the expression builders.

Hope this helps, if you have more questions mail me at

scottr at innoventsolutions dot com