Tokens for multiselect inputs

abovebeyond — Wed, 22 Mar 2017 09:18:47 GMT

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!

Re: Tokens for multiselect inputs

abovebeyond — Wed, 22 Mar 2017 09:52:04 GMT

I use "delimiter" instead , problem solved 🙂

topic Re: Tokens for multiselect inputs in Dashboards & Visualizations

Tokens for multiselect inputs

Re: Tokens for multiselect inputs