SQL CONCAT Issue

s-bolyard

Hello,

I'm trying to create a link that person can click on and it will take them to the Nodes Details page or the Volumes Detail page.  My SQL query is working, but when I click the Allow HTML tags checkbox, the column goes blank.  Has anyone tried this and got it to work?  If so, is it my SQL or my Orion?

SELECT

CONCAT('<a href="'">thwack.solarwinds.com/.../VolumeDetails.aspx )  AS 'Server',

CONCAT('<a href="'">thwack.solarwinds.com/.../VolumeDetails.aspx )  AS 'Volume'

FROM Volumes v

JOIN Nodes n ON v.NodeID = n.NodeID

WHERE n.Caption = '<MyServer>'

natetech

It looks like you forgot to use a close anchor </a>

You also need the NodeID for both the volume and node to reference.

Try something like this

SELECT

CONCAT('<a href="',n.Caption,'</a>')">thwack.solarwinds.com/.../VolumeDetails.aspx  AS 'Server',

CONCAT('<a href="',v.Caption,'</a>')">thwack.solarwinds.com/.../VolumeDetails.aspx  AS 'Volume'

FROM Volumes v

JOIN Nodes n ON v.NodeID = n.NodeID

WHERE n.Caption = '<MyServer>'