0 Replies Latest reply on May 17, 2018 4:40 PM by vinceshy

    SWQL Details Page Link for calculated fields in Custom Table does not work

    vinceshy

      When using a Custom Table on a view, the general way to use the Details Page Link on a field in the table is to include the field and the DetailsUrl field in the SWQL query like this:

       

      SELECT

      NodeName AS [Node],

      DetailsUrl AS [Node|DetailsUrl]

      FROM

      Orion.Nodes

      WHERE

      NodeID = ${NodeID}

       

      This allows for the addition of the Details Page Link display setting for the field on the Table Layout.

       

      Details Page Link

      However the use of a calculated field does not allow this to occur.

       

      SELECT

      Caption AS [Vol],

      TOSTRING(ROUND(b.VolumePercentUsed,0)) + '%' AS [Usage],

      DetailsUrl AS [Usage|DetailsUrl]

      FROM

      Orion.Volumes

      Where

      NodeID = ${NodeID}

       

       

      Details Page Link Error

       

      I have tried this using CASE statements as well, and no dice.

       

      This seems like a bug to me.

       

      Comments?