Dynamic sql based on the condition

new member

Hi,

I have a scenario that I have to create a where cluase based on the data I get from my jsp.

Example:

I have an empId and I need to add that empId condition if i get the id other wise I should not add that condition.

Could somebody help.

Thanks in advance

JasonW

Why not use a beforeOpen event on the dataset like:

var myuser = reportContext.getHttpServletRequest().getSession().getAttribute("myuser");
if( myuser != null ){

this.queryText = this.queryText + " where userid=" + myuser;

}

Jason