Hi, im trying to create a multiple select checkbox with parameters
My checkbox looks like:
<input type="checkbox" token="EventCode"> <label>Event Code:</label> <choice value="'ERROR'">ERROR</choice> <choice value="'Success'">Success</choice> <choice value="'NoValue'">NoValue</choice> <default>'ERROR', 'NoValue'</default> <valueSuffix>,</valueSuffix> </input>
My search is a DBQEURY:
| dbquery "MYDB" "select *
from [dbo].[Mytable]
where NotificationEventCode in ($EventCode$)
order by id desc"
While try to search my search looks like:
"and NotificationEventCode in ('ERROR', 'NoValue',)
How can i remove the "," in the end?
Thanks!
I use "delimiter" instead , problem solved 🙂