topic Re: Eval varible doesnt work at drilldown xml in Dashboards & Visualizations

Eval varible doesnt work at drilldown xml

kennethyeung — Tue, 29 Sep 2020 17:10:31 GMT

       <eval token="t_contract">=strftime(now(), "%y%m")</eval>
      <link > <![CDATA[
      /app/search/option_change?form.tok_contract=$t_contract$
      ]]>
      </link>
    </drilldown>

it will go to anotherview but the link " /app/search/option_change?form.tok_contract=%3Dstrftime(now()%2C "%25y%25m")
seem that it dont know process before pass to link
also tried use " to quote in the URL, also not work.

Thanks

Re: Eval varible doesnt work at drilldown xml

kamlesh_vaghela — Fri, 08 Dec 2017 09:56:48 GMT

HI @kennethyeung,

Can you please try to display form.tok_contract value in option_change dashboard? It is what you expected?

just add.

<row>
    <panel>
      <title>$form.tok_contract$</title>
    </panel>
</row>

Re: Eval varible doesnt work at drilldown xml

harsmarvania57 — Fri, 08 Dec 2017 10:17:21 GMT

Hi @kennethyeung

I have tried below drilldown and it's working fine.

        <drilldown>
          <eval token="t_contract">strftime(now(), "%y%m")</eval>
                 <link > <![CDATA[
       /app/search/test1?form.test1token=$t_contract$
       ]]>
       </link>
        </drilldown>

Sample dashboard with drilldown working fine, in below dashboard I have another dashboard called test1 and that dashboard has Text Input field with token name test1token so when I redirect to another dashboard I got value 1712 in text input.

<form>
  <label>test</label>
  <fieldset submitButton="true" autoRun="false">
    <input type="multiselect" token="field1" searchWhenChanged="false">
      <label>field1</label>
      <choice value="sourcetype">Sourcetype</choice>
      <search>
        <query/>
        <earliest>-24h@h</earliest>
        <latest>now</latest>
      </search>
      <delimiter> </delimiter>
    </input>
    <input type="multiselect" token="field2">
      <label>field2</label>
      <choice value="host">Host</choice>
      <delimiter> </delimiter>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal | stats count by $field1$, $field2$</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <drilldown>
          <eval token="t_contract">strftime(now(), "%y%m")</eval>
                 <link > <![CDATA[
       /app/search/test1?form.test1token=$t_contract$
       ]]>
       </link>
        </drilldown>
      </table>
    </panel>
  </row>
</form>

Re: Eval varible doesnt work at drilldown xml

kennethyeung — Fri, 08 Dec 2017 13:54:42 GMT

Is it related version issue?
I am using 7.0 and free version

Re: Eval varible doesnt work at drilldown xml

elliotproebstel — Fri, 08 Dec 2017 14:01:09 GMT

I'm pretty sure the issue is the = in your eval statement.

<eval token="t_contract">=strftime(now(), "%y%m")</eval>
should actually be
<eval token="t_contract">strftime(now(), "%y%m")</eval>

In the link: /app/search/option_change?form.tok_contract=%3Dstrftime(now()%2C "%25y%25m") the %3D between contract= and strftime is ASCII encoding for =.

Re: Eval varible doesnt work at drilldown xml

harsmarvania57 — Fri, 08 Dec 2017 14:01:13 GMT

Let me try in Splunk 7, above code was test in Splunk 6.6

Re: Eval varible doesnt work at drilldown xml

harsmarvania57 — Fri, 08 Dec 2017 14:17:09 GMT

Working perfectly fine in Splunk 7.0.1, please check again my drilldown code I have already removed =before strftime

Re: Eval varible doesnt work at drilldown xml

kennethyeung — Fri, 08 Dec 2017 15:32:33 GMT

Thanks, i miss i have more = sign .

Re: Eval varible doesnt work at drilldown xml

kennethyeung — Fri, 08 Dec 2017 15:32:39 GMT

Thanks, i miss i have more = sign .