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 and birt-functions-lib

dixie · 2010-10-15T03:17:16+00:00

Hi, I've tried to solve the IN-Clause Problem using the birt-functions-lib as described here http://code.google.com/a/eclipselabs.org/p/birt-functions-lib/wiki/BindParameters As…

dixie

Hi, 
 
I've tried to solve the IN-Clause Problem using the birt-functions-lib as described here 
<a class='bbc_url' href='http://code.google.com/a/eclipselabs.org/p/birt-functions-lib/wiki/BindParameters'>http://code.google.com/a/eclipselabs.org/p/birt-functions-lib/wiki/BindParameters</a> 
 
As explained, I've put a 
 CustomFunctions.BindParameters(this.reportContext); 
into the beforeFactory()-Method of the reportdesign itself. 
 
What I get is an exception because the reportContext is null at this stage: 
 
Caused by: org.eclipse.birt.core.exception.BirtException: ReportContextobject is null in BindParameters 
at innovent.birt.functions.factory.InnoventFunction?.getReportContext(InnoventFunction?.java:105) at innovent.birt.functions.BindParameters.execute(BindParameters.java:119) at 
 
 
 
Any idea? 
And: Is the usage of this lib still the recommended way to solve the IN-clause issue in reports? 
 
Thanks in advance, 
Dirk

Find more posts tagged with

Comments

thuston

I do it like this: 
One workaround to obtain the multi-select parameter values and use them in a SQL WHERE col IN ('val1','val2',...) is to script the DataSet beforeOpen. 
 
You can write your SQL as SELECT ... WHERE col IN ('dummyval'). 
Then Script in the beforeOpen to replace the dummyval. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>var inList = "'" + params["myMultiParam"].value[0] + "'";
if ( params["myMultiParam"].value.length > 1 ) {
for (i=1; i < params["myMultiParam"].value.length, i++){
inList = inList + ",'" + params["myMultiParam"].value[i] + "'"
}
}
this.queryText = new Packages.java.lang.String(this.queryText).replaceAll( "'dummyval'", inList );</pre>

johnw

Dixie, 
 
Yes, we still recommend using the functions lib over just appending parameters to the query statement for the same reasons stated on the project page, its easier to use the same parameter multiple times without needing to create the binding in the data set, you can reference the report parameter being mapped in your query inside the query editor, and the Functions lib bind parameters does input validation. 
 
Make sure you are using the correct version of the functions library for your version of BIRT. There is a 2.3 series and 2.5 series. The 2.5 series should still work in 2.6 as well. 
 
In the beforeFactory, you should use: 
CustomFunctions.BindParameters(reportContext); 
 
this.reportContext is not accessible in the beforeFactory, only in the Initialize event, so in the Initialize event you would use: 
CustomFunctions.BindParameters(this.reportContext); 
 
That should take care of it. I have attached two example report designs. In the multiSelectUsingBinding, I am calling the binding method in beforeFactory, and in FunctionsLibExample, I am calling it in the Initialize event. 
 
Hope that helps, and let me know if you have any other issues. 
 
John 
 
 
<blockquote class='ipsBlockquote' data-author="'dixie'" data-cid="69414" data-time="1287127036" data-date="15 October 2010 - 12:17 AM">
Hi, 
 
I've tried to solve the IN-Clause Problem using the birt-functions-lib as described here 
<a class='bbc_url' href='http://code.google.com/a/eclipselabs.org/p/birt-functions-lib/wiki/BindParameters'>http://code.google.com/a/eclipselabs.org/p/birt-functions-lib/wiki/BindParameters</a> 
 
As explained, I've put a 
 CustomFunctions.BindParameters(this.reportContext); 
into the beforeFactory()-Method of the reportdesign itself. 
 
What I get is an exception because the reportContext is null at this stage: 
 
Caused by: org.eclipse.birt.core.exception.BirtException: ReportContextobject is null in BindParameters 
at innovent.birt.functions.factory.InnoventFunction?.getReportContext(InnoventFunction?.java:105) at innovent.birt.functions.BindParameters.execute(BindParameters.java:119) at 
 
 
 
Any idea? 
And: Is the usage of this lib still the recommended way to solve the IN-clause issue in reports? 
 
Thanks in advance, 
Dirk </blockquote>