Property Binding in Custom Oda

pJune

Hello,

I have a custom oda driver for the data source and data set. I want to be able to add parameters to my report created with my custom oda drivers. I have been looking for examples on how to implement parameters in custom oda drivers, but I have not found anything. I created a query the following query and typed it in the Edit DataSet/Property Binding

"select OID, Name, Description from Study where OID in ( " + " ' " + params["myOidParam"] + " ' )";

but I get the following error:
Caused by: org.eclipse.birt.data.engine.core.DataException: Column binding "Description" has referred to a data set column "Description" which does not exist.

Then, I removed "where OID in ( " + " ' " + params["myOidParam"] + " ' )" and I get the results but without being filtered.

I want to know in what method of the Query class in the oda driver for the data source, or in any other class, I can return the correct result based on the query input in the Property Binding window. If somebody knows an example, that would be great. I was looking at the implementation of the jdbc driver but that does not work for me; because my driver does not connect to a database.

I would appreciate any help.
Thanks in advanced.

JasonW

If you modify the beforeOpen script instead of the property binding does it work?<br />
<br />
eg<br />
var parmcount = params["parmorders"].value.length<br />
var whereclause = "";<br />
if( parmcount > 0 ){<br />
whereclause = " where customernumber in ( ";<br />
}<br />
for( i=0; i < parmcount; i++ ){<br />
if( i == 0 ){<br />
whereclause = whereclause + params["parmorders"].value;<br />
}else{<br />
whereclause = whereclause + " , " + params["parmorders"].value; <br />
}<br />
}<br />
if( parmcount > 0 ){<br />
this.queryText = this.queryText + whereclause + " ) ";<br />
}<br />
<br />
<br />
Jason