Creat Hyperlink in SWQL

As an example you could use something like this:

SELECT  cp.n_company AS [textb],

concat('https://google.com/', cp.n_company) AS [_LinkFor_textb]

FROM Orion.Nodes N

INNER JOIN  orion.NodesCustomProperties cp on cp.nodeid = N.NodeID

This is a great little tip! Glad I found it. Here's what I did to linkify email addresses in a custom widget. (The ComponentID is irrelevant to any of you...it's simply the specific application monitor component that pulls the email address of whoever is on call for each team here.)

SELECT ComponentName AS Team, ComponentMessage AS Contact, CONCAT('<a href="mailto:',Contact,' "/a>',Contact) AS [_LinkFor_Contact] 
FROM Orion.APM.ComponentAlert 
WHERE ComponentID Between 133364 AND 133367

In the custom resource, I ticked the check box to 'Allow HTML tags' in the column's value.