How do I turn DetailsURL into a clickable link within a widget?

stuartd

I've added a very simple SWQL query to a custom widget to display the list of all interfaces that are currently down.

It looks like this:

SELECT 
FullName AS Node_and_Interface, 
OperStatus, 
Alias AS Interface_Name,
IfName, 
InterfaceIndex, 
DetailsUrl

FROM Orion.NPM.Interfaces

--next line selects status as 2 (i.e. DOWN) and where it isn't AdminDown/Shutdown
WHERE OperStatus LIKE '2' AND 'AdminStatus' NOT LIKE '4'

Now, I've read countless posts hereabouts, and even watched KMSigma discussing this in one of the Lab sessions, but no matter what I try, I can't make the 'DetailsUrl' turn into a hyperlink so the engineer can just click through to teh details.

Anybody want to help this old dunce out?

christopher.t.jones123

@stuartd

you have most of it you just need to alias out the details url to [_LinkFor_<Column you want it to be a link for>] so something like below would work

SELECT 
FullName AS Node_and_Interface, 
OperStatus, 
Alias AS Interface_Name,
IfName, 
InterfaceIndex, 
DetailsUrl as [_LinkFor_Interface_Name]

FROM Orion.NPM.Interfaces

--next line selects status as 2 (i.e. DOWN) and where it isn't AdminDown/Shutdown
WHERE OperStatus LIKE '2' AND 'AdminStatus' NOT LIKE '4'