topic How to create a table cell conditional drilldown on click in Splunk Search

How to create a table cell conditional drilldown on click

vikas_gopal — Thu, 09 Jan 2020 02:37:45 GMT

Hi Experts ,

I am preparing a very simple dashboard this will have 2 input text box elements and one table which has 2 columns host and sourcetype . I want to fill sourcetype in texbox1 and if user click on host cell then host value should fill in text box 2 . I used condition but it not working . Here is my current code

<form>
  <label>Test Dashboard</label>
  <fieldset submitButton="false">
    <input type="text" token="a">
      <label>host</label>
    </input>
    <input type="text" token="b">
      <label>sourcetype</label>
    </input>
  </fieldset>
  <row>
    <panel>
      <table>
        <title>test</title>
        <search>
          <query>index=_internal | dedup host,sourcetype|table host,sourcetype</query>
          <earliest>-15m</earliest>
          <latest>now</latest>
        </search>
        <option name="count">10</option>
        <option name="drilldown">cell</option>
        <drilldown>
          <condition field="host">
            <set token="a">$row.host$</set>
            <unset token="b"></unset>
          </condition>
          <condition field="sourcetype">
            <set token="b">$row.sourcetype$</set>
            <unset token="a"></unset>
          </condition>
        </drilldown>
      </table>
    </panel>
  </row>
</form>

Re: How to create a table cell conditional drilldown on click

vnravikumar — Thu, 09 Jan 2020 03:38:11 GMT

Try with form.a and form.b

<form>
   <label>Test Dashboard</label>
   <fieldset submitButton="false">
     <input type="text" token="a">
       <label>host</label>
     </input>
     <input type="text" token="b">
       <label>sourcetype</label>
     </input>
   </fieldset>
   <row>
     <panel>
       <table>
         <title>test</title>
         <search>
           <query>index=_internal | dedup host,sourcetype|table host,sourcetype</query>
           <earliest>-15m</earliest>
           <latest>now</latest>
         </search>
         <option name="count">10</option>
         <option name="drilldown">cell</option>
         <drilldown>
           <condition field="host">
             <set token="form.a">$row.host$</set>
             <unset token="form.b"></unset>
           </condition>
           <condition field="sourcetype">
             <set token="form.b">$row.sourcetype$</set>
             <unset token="form.a"></unset>
           </condition>
         </drilldown>
       </table>
     </panel>
   </row>
 </form>

Re: How to create a table cell conditional drilldown on click

vikas_gopal — Thu, 09 Jan 2020 04:06:57 GMT

Wow such a silly mistake from my side , i would have catch this easily . BTW thank you Kumar.