Using like operator in data set filter [message #830325] |
Tue, 27 March 2012 13:37 |
mkrivic Mising name Messages: 33 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 |
|
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,
|
|
|
Powered by
FUDForum. Page generated in 0.01870 seconds