How to pass Report Parameters via HQL

Hi, 
 
I am using HQL to access data from MySQL Database for my Scripted Data Source through Hibernate. 
 
For passing parameters to my report, I tried passing a query string from my Report Javascript like for example, "from CustomerList where customerName = '?' " (also tried using ? without quotes). 
 
However I am not able to get the report generated. 
 
I created my report based on the following references: 
For Report Parameters - <a class='bbc_url' href='http://download.eclipse.org/birt/downloads/examples/reports/Parameters/Parameters.html'>Created by Camtasia Studio 3</a> 
 
For BIRT-Hibernate Integration - 
Please find attached doc. 
 
Please let me know if I have errored anywhere in my query & how this can be resolved. 
 
Thanks & Regards, 
arvindraj

Find more posts tagged with

Comments

Virgil Dodson

Hi Arvind,

Since you are trying to pass in report parameters using Scripting, you should be able to access the report parameter value directly instead of placing a question mark as a place holder.

Your script will look something like:

customers = cul.listCustomers("from CustomerList where customerName ="+params["CustParameter"].value);

This assumes you have created a customer parameter called 'CustParameter'. While you are in the Script tab, select the BIRT Palette and you can drag your parameter over to the Script area and it will create "params["CustParameter"].value" for you.

arvindraj

It works.
Thank you so much Virgil.

Regards,
Arvind Raj