Eclipse Community Forums: BIRT » Dynamic where clause in Birt

Help

Home

Home » Archived » BIRT » Dynamic where clause in Birt

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

Dynamic where clause in Birt [message #915642]

Mon, 17 September 2012 17:17

Vani Ra

Messages: 11
Registered: September 2012

Junior Member

Here is a question, probably not something new, but I am kind of stuck.

I want to dynamically pass the where clause to birt to generate a report for me. I know how to pass parameters to Birt report but this is something totally different.

My where clause changes altogether in different scenarios. Actually am designing a search page which has many parameters and report is generated based on the values entered by the user. sometime user fills 2 fields and other times he might fill 10 fields.

Say at first, my query is Select * from xx where empNo. is yy

and second time it might be Select * from xx where salary Between 100 and 200

So In short, my where clause is very dynamic. and I want to keep where clause as a parameter and want to pass it to Birt manually at run time instead of pre defining it in data set. Is it possible to meet such requirement ?

Please reply.

Thanks

Report message to a moderator

Re: Dynamic where clause in Birt [message #915661 is a reply to message #915642]

Mon, 17 September 2012 17:47

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

If the structure of the returned resultset does not change, this is very simple. In your example put the select * from xx in the designer. Then in the beforeOpen event handler script put in a script similar to this:

this.queryText = this.queryText + " " + params["youwhereclauseparameter"].value;

Jason

Report message to a moderator

Re: Dynamic where clause in Birt [message #915671 is a reply to message #915661]

Mon, 17 September 2012 18:15

Vani Ra

Messages: 11
Registered: September 2012

Junior Member

awsome

thanks

For future reference, is there any tutorial on such things ? which explains all the features of Birt ?

[Updated on: Mon, 17 September 2012 18:39]

Report message to a moderator

Re: Dynamic where clause in Birt [message #915709 is a reply to message #915671]

Mon, 17 September 2012 20:21

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

We have some older tutorials here:
http://www.eclipse.org/birt/phoenix/examples/reports/birt2.1/querymod/index.php

But on Birt-exchange.org there are a lot of examples. I am also attaching an example.

Jason