Eclipse Community Forums: BIRT » Dynamic where clause in report?

Help

Home

Home » Archived » BIRT » Dynamic where clause in report?(Dynamic where clause in report?)

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

Dynamic where clause in report? [message #631306]

Wed, 06 October 2010 22:38

dash

Messages: 20
Registered: August 2010

Junior Member

Hi,

Based on the user's inputs, the where clause may contain one or two conditions. Is it possible to have a dynamic where clause in the report's query?

For example, if customer name exists, the where clause will become
select * from customers
where customer_name = ?

if both customer name and phone number exist, the where clause will become

select * from customers
where customer_name = ? and customer_phone_number = ?

Thanks,
kenny

Report message to a moderator

Re: Dynamic where clause in report? [message #631419 is a reply to message #631306]

Thu, 07 October 2010 13:55

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

Depending on your back-end database, I'd do something like the following:

where customer_name = ?
and
(customer_phone_number IS NULL or customer_phone_number = ?)

Some databases don't short-cut evaluation and that last clause may have to be written differently.

Report message to a moderator

Re: Dynamic where clause in report? [message #631546 is a reply to message #631419]

Thu, 07 October 2010 22:12

dash

Messages: 20
Registered: August 2010

Junior Member

Hi Rich,

Thanks for your reply. But, I'm looking for a way to dynamically add additional condition(s) to the where clause in the same report instead of depending on the DB engine.

do you know whether it's possible?

thanks,
kenny

Report message to a moderator

Re: Dynamic where clause in report? [message #631562 is a reply to message #631306]

Fri, 08 October 2010 01:22

Richard A. Polunsky

Messages: 212
Registered: July 2009
Location: Houston TX

Senior Member

You can do pretty much whatever you want to the query text (not just the where clause) by clicking on the data set, going to the Script tab and going into the beforeOpen event. There should be a lot of examples of that in the BIRT communities, I'd search for beforeOpen or queryText.

Report message to a moderator

Previous Topic:	Newbie Test
Next Topic:	Using RE API without birt installed on the server machine

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:46:35 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter