BIRT Filter with Like

Hi

I am using the dataset filter. ( Datasets > Edit Dataset > Filters )

I want to select all records with name like ABC.

I select the field on the left, the like operator and then type '%ABC%' on the right.

I do not get any records.

Can anyone please guide me what expression I need to specify in the filter value?

Can you also throw some light on the expressions that can be used?

Any links to documentation on Filter with Like will also help.

Thanks,

Srividya Sharma

Find more posts tagged with

Comments

mwilliams

It works for me just how you're using it. What is your BIRT version? Can you reproduce it not working with the sample database?

pm.nayak84

Hi ,

I am just learning BIRt so using the sample database provide ( Classic Model Inc Sample Database )

I tried with a filter customername like '%?%' and witha DSP parameter and corresponding report parameter .

When i pass report parameter valure as 'A' , its not returning anything and report fails with error .

Let me know if i want to pass a value as report parameter and to use as a like filter , how would i write the filter statement for the same .

Raghava

<blockquote class='ipsBlockquote' data-author="'pm.nayak84'" data-cid="96379" data-time="1329630192" data-date="18 February 2012 - 10:43 PM">
Hi , 
 
I am just learning BIRt so using the sample database provide ( Classic Model Inc Sample Database ) 
 
I tried with a filter customername like '%?%' and witha DSP parameter and corresponding report parameter . 
 
When i pass report parameter valure as 'A' , its not returning anything and report fails with error . 
 
Let me know if i want to pass a value as report parameter and to use as a like filter , how would i write the filter statement for the same . </blockquote>
 
Hi Priya, 
 
In build expression editor,you compose expression like '%'+params["NewParameter"].value+'%'. Here new parameter is your report parameter.let me know if you require any more information. 
 
Raghava