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)

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

Fri, 20 August 2021 10:49

Eclipse User

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.

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

Fri, 20 August 2021 16:27

Eclipse User

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'"
}

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

Mon, 23 August 2021 10:08

Eclipse User

Thank you my friend! I managed to perfectly accomplish what I needed, you helped me a lot!

Previous Topic:	NULL issue
Next Topic:	birt runningsum on group

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Apr 20 23:23:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter