Auto Suggest using Like/wildcard search

Hi Guys,
I am using BIRT 3.4.2. I am trying to use a wildcard search with an Auto Suggest Text box parameter.
Right now the way I have it is:
Computed field in the dataset: ID + NAME
Name of computed field: ID_NAME
Parameter: Text Box - Autosuggest
Display Field: ID_NAME
Value Field: ID

So the user enters the ID and it works well...showing the correct combination of ID+NAME.
But the users want to be able to enter just a name and expect the Auto Suggest box to display all matches for that name or string.
I tried different things including creating the computed field with birtcomp.like() but it gives a dependency error.

Please advise if there is a way or workaround.
Thanks

Find more posts tagged with

Comments

mwilliams

Hi kkrishnan,

Can you recreate your issue with the sample database? Thanks.