Eclipse Community Forums: BIRT » Parameter wildcard value

Help

Home

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

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

Parameter wildcard value [message #1773016]

Wed, 20 September 2017 08:28

hatra atrin

Messages: 12
Registered: February 2014

Junior Member

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

Report message to a moderator

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

Wed, 20 September 2017 19:39

Jerry Sheets

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

Member

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"

Report message to a moderator