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)