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

    Where to find DetailsUrl field for SRM?

    byrona

      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?
          mat12

          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',

          a.Note,a.AccountID,a.TimeStamp

          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