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
Hi
Try this
<drilldown>
<condition match="$row.TFS$ == """></condition>
<condition>
<link target="_blank">https://www.splunk.com</link>
</condition>
</drilldown>
Hi
Try this
<drilldown>
<condition match="$row.TFS$ == """></condition>
<condition>
<link target="_blank">https://www.splunk.com</link>
</condition>
</drilldown>
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$ == """></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?
Hi
try this
<drilldown>
<condition match="$row.TFS$ != """>
<link target="_blank">https://www.splunk.com</link>
</condition>
<condition match="$row.TFS$ == """>
</condition>
</drilldown>
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.
try with
<condition match="$row.TFS$ == "" AND $click.name2$== "TFS""></condition>
<condition match="$row.TFS$ != "" AND $click.name2$== "TFS"">
<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$
That did it! Thank you SO much. I didn't think to also match the column name, brilliant.