Instead of Navigation try to do it HTML link by modifying the for column value something like
select last_name,'<a href=http://localhost/analytics/repName?colname='||dname||'>' from emp
check syntax, and its not straight forward as any BI report.
if helps mark and update us back
The Direct DB Request SQL is very complex, i cannot add a HTML link into that now.
Currently the GO URL looks like below:
I would need to pass a column value in the above URL instead of passing a static value "Energy". Please suggest.