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.