Inserting Node Details URL not working

Question

I have the following simple SWQL query to test inserting the Details URL as a link for the Node column and no matter how I format it the Node caption is not clickable. Any ideas? What am I doing wrong? (This is for a Report if that makes a difference).

SELECT TOP 1000 I.InterfaceName, N.Caption AS Node, N.DetailsUrl as [_LinkFor_Node]
FROM NCM.Interfaces I
INNER JOIN Orion.Nodes N ON I.Node.CoreNodeID = N.NodeID
ORDER BY Node ASC

chad.every · Answer

Looks like you're trying to apply the link to the link column itself. I would try the following (it worked in my lab)

* 1. Edit the dashboard/Widget and delete the _LinkFor_Node column
* 2. Expand out the Column for Node* Format: Link
* Label: Node
* URL: _LinkFor_Node

* Save Changes/Done Editing Dashboard

zap123 · Answer

Set the below option for Link for nodes