1 Reply Latest reply on Jul 5, 2018 5:57 AM by mat12

    Where to find DetailsUrl field for SRM?


      I have created a report from data in SRM using a Custom SQL Query and I want to add the node link to the names of the Storage Arrays in the report; however, I am receiving the following error when attempting to do so:


      NAME - 'Details Page Link' data presenter requires 'db|DetailsUrl' field(s) to be present within the datasource


      Where in the database can I find this information so I can include it in the query?

        • Re: Where to find DetailsUrl field for SRM?

          I am not sure if this is the same, but you can try this sample which shows the notes on a node using custom SQL with the detailsURL of the node:


          SELECT CONCAT('<a href="/Orion/View.aspx?NetObject=N:',a.nodeid,'">',b.caption,'</a>') as 'Caption',


          FROM NodeNotes a

          INNER JOIN NodesData b on a.NodeID=b.NodeID

          ORDER BY a.TimeStamp DESC


          Note: Do not enable the details page link on the column anymore.

          This will automatically create a hyperlink of the node in caption.


          Hope this helps