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 eh.id)) / lag(eh.nlopecost) over (order by eh.id)) * 100)||'%' OPEV_Cost

 

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

 

Thanks.

Outcomes