Hi there,
I have searched far and wide for a solution this problem but no luck so I was hoping someone out there could help me. I have a list of task names stores inside an oracle database. I need the user to be able to search for the names in the multiselect box, show them in the dropdown and select them as part of the multi select. Each name value selected must be comma delimited. I have posted my current code which does not work and I am hoping someone out there is able to help me.
Thanks alot.
<input type="multiselect" token="taskname">
<label>Specify task names that you are interested in</label>
<choice value="^">All</choice>
<default>^</default>
<delimiter>,</delimiter>
<fieldForLabel>taskname</fieldForLabel>
<fieldForValue>taskname</fieldForValue>
<search>
<query>| dbxquery connection=PROD_DB query="SELECT TASK_NAME FROM TASK_RUN WHERE TASK_NAME LIKE '$taskname$%Supertask%' OR TASK_NAME LIKE '%Supertask%$taskname$'"</query>
</search>
</input>
... View more