Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Using like operator in data set filter
Using like operator in data set filter [message #830325] Tue, 27 March 2012 13:37 Go to next message
mkrivic Mising name is currently offline mkrivic Mising name
Messages: 32
Registered: May 2010
Member
Hi,

I have situation where I must use LIKE operator two times for same value.

So, I have report parameter which consists list of letters. So, I must retrieve all values which start with chosen letter. I put in filter next:

row["name"] like "params["letter"].value+"%" and this works.

But when I choose more letters from my parameter, I get an empty list.
So, my question is, how I can use LIKE operator in filter to work with more than one value, in my case, two values?

Regards,
Re: Using like operator in data set filter [message #830784 is a reply to message #830325] Wed, 28 March 2012 03:41 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

I assume the parameter is a multselect parameter? If so multiple values
are accessed like

params["letter"].value[0]
params["letter"].value[1]
and you can get the length like:
params["letter"].length

Look at the filter on the attached reports dataset to see a similar way
of doing what you need.

Jason

On 3/27/2012 9:37 AM, mkrivic Mising name wrote:
> Hi,
> I have situation where I must use LIKE operator two times for same value.
>
> So, I have report parameter which consists list of letters. So, I must
> retrieve all values which start with chosen letter. I put in filter next:
>
> row["name"] like "params["letter"].value+"%" and this works.
>
> But when I choose more letters from my parameter, I get an empty list.
> So, my question is, how I can use LIKE operator in filter to work with
> more than one value, in my case, two values?
>
> Regards,
Previous Topic:out of memory error
Next Topic:Performance is better with firefox
Goto Forum:
  


Current Time: Thu Oct 23 12:38:08 GMT 2014

Powered by FUDForum. Page generated in 0.02551 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software