String used in hyperlink made out of SELECT statement

domagaj

Hi,

I have a log server. I want to create a hyperlink in SWQL that would get a portion of a hyperlink, then get IP addresses of nodes per location, then rest of the link.

So basically I want to create a single string using SELECT within it.

Here is what I thought will work:

SELECT REPLACE('<a href="logservser.mycompany.com/search, 'PATTERN', (SELECT 'node%3D%22' + ToString([N].[IPAddress]) + '%22%20OR%20' FROM Orion.Nodes AS [N] Where Location = ${Location}))

Or the same without the leading SELECT.

Yet after many tries I start to think this is impossible. Please prove me wrong Thank you!

wluther

@domagaj I'm not sure if this is what you are talking about, but you can use the CONCAT function to easily string together just about whatever you want. Combined with the [_LinkFor_] label, you should be able to build out all sorts of custom links.

SELECT
n.NodeID
,n.Caption
,n.IPAddress
,'NewURL' AS CustomLink
,CONCAT('https://logservser.mycompany.com/search?q=filters filters',n.NodeID,n.IPAddress,'&linksettings') AS [_LinkFor_CustomLink]
FROM Orion.Nodes AS n
WHERE n.NodeID=${NodeID}

Does this get you where you need to be, or am I way off here?

Thank you,

-Will