topic Re: Set a token by open a dashboard based on a search in Dashboards & Visualizations

Set a token by open a dashboard based on a search

criedman — Fri, 08 Jun 2018 08:56:48 GMT

Hi,

is it possible to set a token based on a search result value ?
My search does not work ... =(

 <init>
      <eval token="init">| inputlookup Lookup_1 | search Value="Value_A" | eval valuestatus=Value_A | table valuestatus</eval>
   </init>

Value_A = 0 .... 0 Should be set to the token.

BR
Christoph

Re: Set a token by open a dashboard based on a search

kamlesh_vaghela — Fri, 08 Jun 2018 09:28:30 GMT

Hi @criedman

Can you please try following?

  <dashboard>
     <search>
        <query>| inputlookup Lookup_1 where Value="Value_A" 
 | eval valuestatus=Value_A 
 | table valuestatus
        <done>
          <set token="init">$result.valuestatus$</set>
        </done>
      </search>
    </dashboard>

Re: Set a token by open a dashboard based on a search

niketn — Fri, 08 Jun 2018 09:36:07 GMT

@kamlesh_vaghela, where can be added to base inputlookup command to pull only required result instead of fetching all records from lookup file and then filtering specific record.

| inputlookup Lookup_1 where Value="Value_A" 
| eval valuestatus=Value_A 
| table valuestatus

Re: Set a token by open a dashboard based on a search

criedman — Mon, 11 Jun 2018 09:25:32 GMT

Thats the soluten thank you.

   <dashboard>
      <search>
         <query>| inputlookup Lookup_1 where Value="Value_A" 
  | eval valuestatus=Value_A 
  | table valuestatus
         <done>
           <set token="init">$result.valuestatus$</set>
         </done>
       </search>
     </dashboard>

BR
Christoph