Eclipse Community Forums: BIRT » Removing a dataset where clause based on parameter

Home » Archived » BIRT » Removing a dataset where clause based on parameter(Removing a dataset where clause based on parameter)

Show: Today's Messages :: Show Polls :: Message Navigator

Removing a dataset where clause based on parameter [message #1402788]

Thu, 17 July 2014 13:54

Keith Clark

Messages: 11
Registered: July 2014

Junior Member

Hi All.

Try to accomplish what I thought would be a simple task.

I have a query that has the following where clause:

WHERE entereddate BETWEEN ? AND ?
AND siteid = ?

I have report parameters for the start and end dates that are text boxes and a radio selection for the siteid.

What I would like to do is add tot eh radio button an "All" selection that if selected, basically removes the "AND siteid = ?" portion of the sql and selects all sites.

Any suggestions?

Thanks,
Keith

Report message to a moderator

Re: Removing a dataset where clause based on parameter [message #1402843 is a reply to message #1402788]

Thu, 17 July 2014 19:00

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

You can modify the query (this.queryText) in the beforeOpen method. So, you could either check the parameter value and remove the And siteid portion or check the parameter and add it.

Michael

Developer Evangelist, Silanis

Report message to a moderator