topic Re: How do you have a drilldown condition use Field AND Match? in Dashboards & Visualizations

How do you have a drilldown condition use Field AND Match?

jmillerim2 — Thu, 28 Mar 2019 18:50:44 GMT

I'm trying to build a dynamic drilldown for some columns in my table. I currently have my drilldown set using <condition> and field= and this way each field sends you to a unique URL based on the column. But what I also want is to be able to NOT open up a new window if the field they clicked on is blank. So something like:

<condition field="TFS" match="isnotnull($row.TFS$)>

but that doesn't work. I also tried nesting the conditions but that didn't work either:

<condition field="TFS">
  <condition match="isnotnull($row.TFS$)>

Please advise on a way to apply both conditions to a user click in a specific column in a table.

Thank you

Re: How do you have a drilldown condition use Field AND Match?

vnravikumar — Thu, 28 Mar 2019 22:30:04 GMT

Try this

<drilldown>
          <condition match="$row.TFS$ == &quot;&quot;"></condition>
          <condition>
            <link target="_blank">https://www.splunk.com</link>
          </condition>
        </drilldown>

Re: How do you have a drilldown condition use Field AND Match?

jmillerim2 — Thu, 28 Mar 2019 22:36:27 GMT

Thanks for the help! So that actually worked, but because I messed up my explanation of the problem it didn't work with everything else. I actually have 3 different columns that link to different URL's. Here is my drilldown section right now:

      <drilldown>
      <condition match="$row.TFS$ == &quot;&quot;"></condition>
      <condition>
        <link target="NewWindowTFS">$Internal Address$/$row.TFS$</link>
      </condition>
      <condition field="Ticket Number">
        <link target="NewWindowTicket">$Internal Address$/$click.value2$</link>
      </condition>
      <condition field="VSO">
        <link target="NewWindowVSO">$Internal Address$/$row.Product$/_workitems/edit/$row.VSO$</link>
      </condition>
      <condition field="State"></condition>
      <condition field="Agent"></condition>
      <condition field="Release"></condition>
      <condition field="Date Bug Created"></condition>
      <condition field="Date Ticket Created"></condition>
    </drilldown>


So your solution works, but it kills all my other links and only works for my TFS column. Is there a way to have it work for all 3 of my columns that link to a URL?

Re: How do you have a drilldown condition use Field AND Match?

vnravikumar — Thu, 28 Mar 2019 22:51:45 GMT

try this

 <drilldown>
          <condition match="$row.TFS$ != &quot;&quot;">
            <link target="_blank">https://www.splunk.com</link>

          </condition>
          <condition match="$row.TFS$ == &quot;&quot;">
          </condition>
        </drilldown>

Re: How do you have a drilldown condition use Field AND Match?

jmillerim2 — Thu, 28 Mar 2019 23:08:21 GMT

That doesn't work either. If my TFS column is blank then it doesn't allow any of the other fields work. I still want it to check which column is clicked so the URL's are unique based on what they click, but then don't link at all if the field is blank.

Re: How do you have a drilldown condition use Field AND Match?

vnravikumar — Thu, 28 Mar 2019 23:30:26 GMT

try with

<condition  match="$row.TFS$ == &quot;&quot; AND $click.name2$== &quot;TFS&quot;"></condition>
       <condition match="$row.TFS$ != &quot;&quot; AND $click.name2$== &quot;TFS&quot;">
         <link target="NewWindowTFS">http://corp-tfs05:8080/tfs/NDCollection/NetDocuments/_workitems?id=$row.TFS$</link>
       </condition>

if TFS is leftmost column then give $click.name$

Re: How do you have a drilldown condition use Field AND Match?

jmillerim2 — Thu, 28 Mar 2019 23:47:27 GMT

That did it! Thank you SO much. I didn't think to also match the column name, brilliant.