I need to have objects which have sum and avg of certain columns along with other column values as properties . The sql uses group by.

Is there a way to have these aggregate values as part of the class? I really appreciate any help.

In the docs, I read that this is possible in report queries which is outputted immediately before session close. But this is not assigned to the persistent class

Thanks

I'm not sure I understand what you want. As I see it, your object should have either the calculated aggregate, or a persistent value.

For example, pretend you have a table of assets, where each asset has a value. You may want to know what the total value of assets is. You can either store a persistent number in the database, or you can calculate the total at any time you need it.

If you try to store the total, rather than calculate it when you need it, what happens when one of the assets values is updated, or when an asset is inserted or deleted? Won't the stored value then be out-of-date?

Is it really necessary to have the aggregates and the other column values in the same object? Maybe you can provide more details of your application.

John.

If I unsdrestant what do you see, you have to map this properties using formula attribute. For example:



or,



I hope help you.

Thanks for your reply..Let me explain my situation more...

I have a table with columns - siteid, channelid, sent, errors.

I want to create a table with siteid, channelid, total sent, total errors group by siteid and channelid.

Basically my mapped class should hold values of siteid, channelid, total sent for each site+channel combination and total errors for each site+channel combination .

I dont know how to have the total values map to the class..

I have seen examples of how to execute a native query and loop through rows to display values including aggregate values..But these are not mapped to any class...Also we need to keep the session open until we loop through the rows.

I really appreciate any help in this regard...

Thanks
attups