Eclipse Community Forums: BIRT » Create Multiple Filters in an SQL Query

Home » Archived » BIRT » Create Multiple Filters in an SQL Query - Connecting via JDBC( Create Multiple Filters in an SQL Query - Connecting via JDBC)

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

Create Multiple Filters in an SQL Query - Connecting via JDBC [message #1843853]

Fri, 20 August 2021 14:49

Igor Davanço

Messages: 7
Registered: August 2021

Junior Member

Good morning people!
How are you?
I'm developing a report in BIRT that uses the JDBC connection, I would like to create a SQL query receiving parameters, but I would like to test these parameters (by IF-ELSE for example) and depending on the parameters that are informed selects the WHERE clause I need. In BIRT is it possible to do this? How would it be? I'm in doubt.

Report message to a moderator

Re: Create Multiple Filters in an SQL Query - Connecting via JDBC [message #1843860 is a reply to message #1843853]

Fri, 20 August 2021 20:27

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

I do that by extending the SQL Query Where Clause in the Data Set beforeOpen method similar to the following:

// Append Where Clause for Status
if (params["rprmReport"].value == "Ready"){
this.queryText = this.queryText + " AND ae_cp_consult_inv.status_code = 'READY FOR INTERFACE'"
}
if (params["rprmReport"].value == "Sent"){
this.queryText = this.queryText + " AND ae_cp_consult_inv.status_code = 'SENT TO FINET'"
}
if (params["rprmReport"].value == "Error"){
this.queryText = this.queryText + " AND ae_cp_consult_inv.status_code = 'VALIDATION ERROR'"
}

Report message to a moderator