Importing DetailsUrl as a Details Page Link with Tooltip into a Custom Table

Do you want this as a "Report" because that's how you are building it or as a custom SWQL query widget on a page?

This is being built as a custom table widget for use in a view, however same principle would apply if creating a table for a report. 

That's correct, but for a custom widget, you can use the _LinkFor_<FieldName> alias to automatically show the links you want to use, and they honor it.  This is a very simple example:

SELECT [I].Node.Caption AS [Node Name]
     , [I].Node.DetailsUrl AS [_LinkFor_Node Name]
     , '/Orion/StatusIcon.ashx?entity=Orion.Nodes&status=' + Replace(ToString([I].Node.Status), ' ', '') + '&size=small' AS [_IconFor_Node Name]
     , [I].Caption AS [Interface Name]
     , '/Orion/StatusIcon.ashx?entity=Orion.NPM.Interfaces&status=' + Replace(ToString([I].Status), ' ', '') + '&size=small' AS [_IconFor_Interface Name]
     , [I].DetailsUrl AS [_LinkFor_Interface Name]
FROM Orion.NPM.Interfaces AS [I]
WHERE [I].InBandwidth <> 0
 AND  [I].OutBandwidth <> 0
ORDER BY [I].Node.Caption, [I].Index

There are more details about syntax like this in SolarWinds Lab #91.

That's correct, but for a custom widget, you can use the _LinkFor_<FieldName> alias to automatically show the links you want to use, and they honor it.  This is a very simple example:

SELECT [I].Node.Caption AS [Node Name]
     , [I].Node.DetailsUrl AS [_LinkFor_Node Name]
     , '/Orion/StatusIcon.ashx?entity=Orion.Nodes&status=' + Replace(ToString([I].Node.Status), ' ', '') + '&size=small' AS [_IconFor_Node Name]
     , [I].Caption AS [Interface Name]
     , '/Orion/StatusIcon.ashx?entity=Orion.NPM.Interfaces&status=' + Replace(ToString([I].Status), ' ', '') + '&size=small' AS [_IconFor_Interface Name]
     , [I].DetailsUrl AS [_LinkFor_Interface Name]
FROM Orion.NPM.Interfaces AS [I]
WHERE [I].InBandwidth <> 0
 AND  [I].OutBandwidth <> 0
ORDER BY [I].Node.Caption, [I].Index

There are more details about syntax like this in SolarWinds Lab #91.

Nice. Thanks for the info on the Custom Query Widget. I will look into it. I think for my solution as a "Custom Table Widget" I can use the feature that is discussed in the answer here

https://thwack.solarwinds.com/product-forums/the-orion-platform/f/report-lab/8654/swql-report---details-page-link-not-available

and actually build the links. It seems to be working so far. I will post updated code after I get it all working. It may have been easier to just create as you have suggested a "Custom Query Widget." Thanks for the help. 

Excellent.  I don't want to speak out of class, but the issue I encountered was having more than one DetailsURL in the report writer.  It doesn't seem to know which one is which and just picks whatever it wants.  That's one of the reasons that I'm a very big fan of the Custom Query Widget - I get to build it exactly as I want.

Folowup question:

Should the _IconFor_Node Name  work within a Custom Table Widget?

No, because the Custom Table Widget uses the reporting engine, which does not recognize the _IconFor_<Field> and _LinkFor_<Field> aliases as it has it's own mechanisms for handling icons and links.

Thanks for your response. Additionally, is it possible to display html within a column in a Custom Query Widget?

It is, you just need to check the box that lets you display HTML (under the field selector drop-down).

I believe that is within a Custom Table Widget. Is it possible to display HTML within a Custom Query Widget?

Sorry - read too fast - need more .  Yes, you just need to honor the standard HTML tagging syntax.  There are some people that have done some amazing things with custom HTML within query widgets.  Honestly, I only know enough HTML and CSS to be dangerous, so I defer to smarter people when they want things 'pretty.'

OK, attached is some code for the entity field of an alert display. The code displays the html correctly within a Custom Table Widget but does not within a Custom Query Widget. Do yo see what I'm missing to get it working within a Custom Query Widget?

CASE
WHEN AlertObjects.EntityType = 'Orion.Groups'
THEN CONCAT('<b>Group</b> <a href="', AlertObjects.EntityDetailsUrl, '">', AlertObjects.EntityCaption, '</a>')
WHEN AlertObjects.RelatedNodeCaption IS NULL OR AlertObjects.RelatedNodeCaption = AlertObjects.EntityCaption
THEN CONCAT('<a href="', AlertObjects.EntityDetailsUrl, '">', AlertObjects.EntityCaption, '</a>')
WHEN AlertObjects.RelatedNodeCaption != AlertObjects.EntityCaption
THEN CONCAT('<a href="', AlertObjects.EntityDetailsUrl, '">', AlertObjects.EntityCaption, ' <b>on</b> ', '<a href="', AlertObjects.RelatedNodeDetailsUrl, '">', AlertObjects.RelatedNodeCaption, '</a></a>')
ELSE 'Not Defined'
END AS Entity,

This maybe a better way of asking .....

I know this works. 

SELECT 'Hello World' as hello, '/Orion/SummaryView.aspx?ViewID=1' as _LinkFor_hello
FROM Orion.Sites

What is the syntax to include html inline within a Custom Query Widget?

This doesn't work......