Dashboards & Visualizations

Conditional set token in form input

thilleso
Path Finder

Hi,

In a dashboard I'm doing an initial token-setting search, using a lookup and a previously chosen token $token_process$.

In the lookup table columns may have a string value or be empty, and I want to save the non-empty values, but I can't seem to get it to work. Can someone help with the condition syntax?

It's possible the tokens step1...step4 each must have a condition and be set individually.

<search id="tokensearch">
  <query>| inputlookup lookup_e2e where (Key=$token_process$) | fields ProcessId, EndToEnd, Trigger, Step1, Step2, Step3, Step4</query>
  <earliest>-60m@m</earliest>
  <latest>now</latest>
  <finalized>
    <condition !-- Set these tokens always>
      <set token="token_processid">$result.ProcessId$</set>
      <set token="token_e2e">$result.EndToEnd$</set>
      <set token="token_trigger">$result.Trigger$</set>
    </condition>
    <condition !--Set tokens if their values are not NULL>
      <set token="token_step1">$result.Step1$</set>
      <set token="token_step2">$result.Step2$</set>
      <set token="token_step3">$result.Step3$</set>
      <set token="token_step4">$result.Step4$</set>
    </condition-->
  </finalized>
</search>

Regards,
Thomas

0 Karma

sundareshr
Legend

Try this

| inputlookup lookup_e2e  | search Key=$token_processed* | fields ProcessId, EndToEnd, Trigger, Step1, Step2, Step3, Step4
0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

.conf26 Registration is Live: Secure Your Early Bird Pass Now

  Lock in Your Spot: Registration Open for .conf26 in Denver Hello Splunkers, I have exciting news! Your ...

Mile High Learning with Splunk University, Denver, Colorado

If Denver is known for its mile-high elevation, Splunk University is about to raise the bar on technical ...

IT Service Intelligence 5.0 Series: Your Guide to the June Launch

We are excited to announce the June release of Splunk IT Service Intelligence (ITSI) 5.0. This update ...