Eclipse Community Forums: BIRT » Parameter wildcard value

Home » Archived » BIRT » Parameter wildcard value(using wildcard in poarameter default value)

Parameter wildcard value [message #1773016]

Wed, 20 September 2017 04:28

Eclipse User

Hi experts,

a very urgent question regarding setting parameter default value as wildcard,

I am using sql queries, I have a set of parameters strings and ints, I have applied * and % but it doesn't seem to work,

dataset query:

select x,c,v,b,n

where c= ?

and v=?

b =?

dataset parameter:

param 1 linked c

param2 linked v

param3 linked b

report parameter:

c

type= string

Default value ( here I want to apply a wild card where user can either run and get all Cs or change and write a string where they run the report )

here is more info

BIRT Report Designer 2.6.1 Report Version 3.2.22 ( RCP)

any help appreciate it,

thanks

Re: Parameter wildcard value [message #1773048 is a reply to message #1773016]

Wed, 20 September 2017 15:39

Eclipse User

The way that I handle this is to remove the ? marks and data set parameters and use a 'beforeOpen' script instead. I use something like the following that basically allows you to do almost any thing you can do in SQL

// Append Where Clause for Agency
if (params["rprmAgency"].value != "ALL"){
this.queryText = this.queryText + " and ROOT.AE_B_LSE_E.COMPANY_ID = '" + params["rprmAgency"]+"'"
}

// Append Where Clause for Option Status
if (params["rprmStatus"].value != "ALL"){
this.queryText = this.queryText + " and (ROOT.AE_B_OPN_D.ACTIVE is Null or ROOT.AE_B_OPN_D.ACTIVE = 'Y')"
}

// Append Order By Clause
this.queryText = this.queryText + "order by ROOT.AE_B_OPN_D.LEASE_NO,ROOT.AE_B_OPN_D.SEQ_NUM"

Re: Parameter wildcard value [message #1773049 is a reply to message #1773016]

Wed, 20 September 2017 15:39

Eclipse User

Re: Parameter wildcard value [message #1773478 is a reply to message #1773049]

Thu, 28 September 2017 09:39

Eclipse User

thanks it is working now :)

Previous Topic:	Birt 4.6 intergration with Wildfly 10.1.0
Next Topic:	Filed colour

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 03 17:58:33 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter