topic Re: Using a token in a search in Dashboards & Visualizations

Using a token in a search

dbcase — Thu, 30 Nov 2017 15:41:50 GMT

Hi I have this XML code

<input type="dropdown" token="mso_selection">
      <label>Select a MSO</label>
      <search>
        <query>index=wholesale_app  sourcetype=wholesale_mobile_app | spath buildTarget  | dedup buildTarget</query>
        <earliest>-1d</earliest>
        <latest>now</latest>
      </search>
      <fieldForLabel>buildTarget</fieldForLabel>
      <fieldForValue>buildTarget</fieldForValue>
    </input>

 <input type="radio" token="Product_token">
        <label>Select a Product</label>
       <choice value="All">All</choice>
       <choice value="Converge">Converge</choice>
       <choice value="Touchstone">Touchstone</choice>
       <default>All</default>
       <change>
         <condition value="All">
           <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=39 OR Properties.index=40|dedup clientSessionId|table clientSessionId]</set>
           <unset token="productsearchquery"></unset>
         </condition>
         <condition value="Converge">
           <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=39|dedup clientSessionId|table clientSessionId]</set>
          <unset token="productsearchquery"></unset>
          </condition>
          <condition value="Touchstone">
           <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=40|dedup clientSessionId|table clientSessionId]</set>
          <unset token="productsearchquery"></unset>
          </condition>


       </change>
     </input>

And then I have this query

<query>index=wholesale_app buildTarget=$mso_selection$ analyticType=SessionStart $productsearchquery$   |lookup phone_models_edited.csv Model AS Properties.platformData.HM
 | stats count  by   Display_model | rename  Display_model as "Phone Model" count as Count|sort -Count</query>

And the panel on the dashboard sits there saying waiting for input even after everything is selected. Where am I going wrong?

Re: Using a token in a search

dbcase — Thu, 30 Nov 2017 15:53:17 GMT

a bit more information.... if I remove $productsearchquery$ the panel works. So the problem is setting that token somehow but I can't seem to figure out why its not being set....

Re: Using a token in a search

kamlesh_vaghela — Thu, 30 Nov 2017 15:55:12 GMT

HI @dbcase,

You are setting productsearchquery in all three condition and very next unsetting the same token. Is it right?

<condition value="All">
            <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=39 OR Properties.index=40|dedup clientSessionId|table clientSessionId]</set>
            <unset token="productsearchquery"></unset>
          </condition>
          <condition value="Converge">
            <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=39|dedup clientSessionId|table clientSessionId]</set>
           <unset token="productsearchquery"></unset>
           </condition>
           <condition value="Touchstone">
            <set token="productsearchquery">[search index=wholesale_app buildTarget=$mso_selection$ analyticType=Checkpoint     Properties.index=40|dedup clientSessionId|table clientSessionId]</set>
           <unset token="productsearchquery"></unset>
           </condition>

Bcoz, same token productsearchquery you are using in search query.

<query>index=wholesale_app buildTarget=$mso_selection$ analyticType=SessionStart $productsearchquery$    |lookup phone_models_edited.csv Model AS Properties.platformData.HM
  | stats count  by   Display_model | rename  Display_model as "Phone Model" count as Count|sort -Count</query>

Thanks

Re: Using a token in a search

micahkemp — Thu, 30 Nov 2017 15:55:51 GMT

What is the point of <unset token="productsearchquery"></unset> after each <set>?

Re: Using a token in a search

dbcase — Thu, 30 Nov 2017 16:00:17 GMT

Found it......

Re: Using a token in a search

micahkemp — Thu, 30 Nov 2017 16:03:10 GMT

Do you mind posting the solution you found?

Re: Using a token in a search

kamlesh_vaghela — Thu, 30 Nov 2017 16:03:47 GMT

Is it the issue due to <unset token="productsearchquery"></unset> ?

Re: Using a token in a search

nkkn87 — Thu, 28 Feb 2019 08:32:07 GMT

Yes, I would like to know the answer too.