Dashboard drilldown : user clicks on a value, a query is run on selected value , query result (a url) opens new web page

[tripathi07]

HI,

I have to create a drilldown for dashboard. I want to provide user with ability to click on a value in dashboard, then run a new query on selected (clicked) value and use the query result returned (a external link url) to be opened on a new web page. 

So basically following is the query, "drilldown_srch", that should work on value clicked "ID" and query result, "answer" which is a url link,  needs to be opened on new web page. 

<condition field="ID">         

<set token="drilldown_srch">|getreport __EXECUTE__ $row.ID$ | table answer</set>

<link target="_blank">$click.answer|n$</link>

 </condition>

I am looking for how to execute "drilldown_srch" query.

Thanks.