Calculating sum of column using Groovy Sum Function
873210Jan 30 2012 — edited Jan 30 2012Dear All,
We are using jdeveloper 11.1.1.2.0
I have to find the sum of a column salary in a vo.
For this i created a transient attribute in the vo, and set its value to VesselVO2.sum("salary").
And I am getting the sum of all the rows in the table successfully.
My issue is ,I have a view criteria in the vo. When I apply the view criteria I want the sum of the result rowset, but instead I am still getting the sum of all the rows in the table.
What could be the issue?
I have set the updatable property of the attribute to always.
The vo is a read only vo.
Please advice,
Susan