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; } } }

Passing entire query as Parameter to BIRT Report from JSP through url

Nagalakshmi Venkatesan

Hi,
I have a report .I want to pass my entire query(assigned to variable) to BIRT dataset before open from JSP through URL. Is there any option to do that. Please suggest.
ex:
In jsp:
Var query = "select *....";
windows.open=url+"&queryParam="+query;
 
In BIRT:
I have created report parameter(queryParam). I am doing the following on beforeopen condition of dataset.
var condition = params["queryParam"];
this.queryText = this.queryText + condition;
 
I am able to pass parameters from Jsp to report through url. But I am not able to pass query like this.

Find more posts tagged with

Comments

micajblock

From a security perspective this is a VERY bad idea as this can open up to SQL injection hacks. What is the use case here?

Nagalakshmi Venkatesan

In my query i have more than ten conditions. So instead of passing values for those parameters from jsp to report through url,i tried to pass entire query using variable.Can you please tell me,is there any other way to values for the conditions mentioned in th report dataset through url. and if there is no value, i want to apply % for the condition

micajblock

Passing whole where clauses is also not recommended. What is wrong with 10 parameters? In any case for optional parameters just add the specific portion of the where clause. 
<pre class="_prettyXprint">
this.queryText = this.queryText + "columname=" + params["myParam"];</pre>
You might need to insert in the middle somewhere depending on your SQL.