Replacing wildcards in parameters

Hi All, please forgive me if this is asking the obvious but I can not work it out.

I have a report that is linked to my SQL database the query that I run has parameters in it, all of my users are used to using '*' as a wild card but when doing a like in SQL you need the '%'.

Is there a nice way in BIRT to allow the user to input into the parameter a '*' and then replace in the backgound with a '%' before running the query?

Hope that makes sense

Thanks in advance for any help from a newbie.

Find more posts tagged with

Comments

Hans_vd

Hi PikeyBoy, 
 
You can write this script in the parameter validate script: 
<pre class='_prettyXprint _lang-auto _linenums:0'>params["wildcardParam"].value = params["wildcardParam"].replace("*","%");
true;</pre>
 
Hope this helps 
Hans

PikeyBoy

Hans,

Great thanks for that works a treat, its just knowing where to look.

Thanks for the speedy reply.

Ian

vaibhav_bhagwat

Hi Hans_vd,

I want to do some customization in advance search xcelerator contains(wild card values). please suggest me, I need to add a wild card parameter in list

Thanks in advance