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

This can be easily accomplished as long as the field is named DetailsUrl within the query. In the following example the DetailsUrl is actually named EntityDetailsUrl and will not allow the selection of a Details Page Link. 

This query returns all unacknowledged alerts. I was able to reference the Node DetailsURL by creating a JOIN to the node table from the AlertObjects table using the RelatedNodeCaption and this allowed the Detail Page Link to be displayed. Does anyone have an idea of how to include the EntityDetailsUrl. 

SELECT DISTINCT Node.Caption AS Node, Node.DetailsUrl AS NodeDetails, AlertObjects.EntityCaption AS Entity, AlertObjects.EntityDetailsUrl AS EntityDetails, AlertConfigurations.Name AS ALERT, AlertActive.TriggeredMessage AS Message
FROM Orion.AlertObjects AlertObjects
JOIN Orion.AlertActive AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID
JOIN Orion.AlertConfigurations AlertConfigurations ON AlertConfigurations.AlertID=AlertObjects.AlertID
JOIN Orion.Nodes Node ON Node.Caption=AlertObjects.RelatedNodeCaption
WHERE (AlertActive.Acknowledged is Null OR AlertActive.Acknowledged = 'False')
This Datasource allowed the Node to be displayed with the Details Page Link
I was able to get the entity displayed this way for interfaces by creating a JOIN to the Interface table on the EntityDetailsUrl, however this filtered the query to only display alerts where the entity is an interface. 
SELECT DISTINCT Node.Caption AS Node, Node.DetailsUrl AS NodeDetails, Interfaces.Caption AS Interface, Interfaces.DetailsUrl AS InterfaceDetails, AlertConfigurations.Name AS ALERT, AlertActive.TriggeredMessage AS Message FROM Orion.AlertObjects AlertObjects
JOIN Orion.AlertActive AlertActive ON AlertObjects.AlertObjectID=AlertActive.AlertObjectID  
JOIN Orion.AlertConfigurations AlertConfigurations ON AlertConfigurations.AlertID=AlertObjects.AlertID
JOIN Orion.Nodes Node ON Node.Caption=AlertObjects.RelatedNodeCaption
JOIN Orion.NPM.Interfaces Interfaces ON Interfaces.DetailsUrl = AlertObjects.EntityDetailsUrl
WHERE (AlertActive.Acknowledged is Null OR AlertActive.Acknowledged = 'False')
Any ideas????
Parents Reply Children
No Data