Replacing wildcards in parameters
Options
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.
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.
0
Comments
-
Hi PikeyBoy,<br />
<br />
You can write this script in the parameter validate script:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>params["wildcardParam"].value = params["wildcardParam"].replace("*","%");
true;</pre>
<br />
Hope this helps<br />
HansWarning No formatter is installed for the format ipb0 -
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
0
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 124 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax