AnsweredAssumed Answered

NSQL Query and Portlets

Question asked by chrisflynn on Aug 29, 2017
Latest reply on Sep 7, 2017 by Robert Ensinger

My question is,


If you create a portlet from a NSQL query, any fields you get from the query are not editable. Meaning when I place these fields in a portlet I cannot click on these fields and change the values. Is that correct?


Secondly I can do this with a portlet that is created from a object. I can then click on a field in the portlet and update that field.

My issue is I want to be able to create a grid portlet that I can update and have a calculated fields in the same portlet. I know you can create a calculated attribute but a calculate attribute within the object has limitations. I need to be able to do the calculation of two fields with SQL.

Is there a way of combining a object grid portlet and a NSQL grid portlet to have the best of both worlds. One of the calculations I am trying to create in my portlet is shown below. I don't think I can do this calculation in a object calculated attribute


Round(((eh.nlopecost - lag(eh.nlopecost) over (order by / lag(eh.nlopecost) over (order by * 100)||'%' OPEV_Cost


Any help would be much appreciated. (I am using Clarity PPM 13.3)