Form/Chart based on aggregate query

umesh

Hi,

How can we show tabular based on aggregate SQL queries.

My business object 'WASTE' is owner of another business object 'WasteDisposal'. I want to show the total waste disposed based on summation of quantity atribute of business object 'WasteDisposal' like

Waste Total quantity
ABC 100
VGDF 200

Thanks

aware_support

SUM WasteDisposal.Quantity WHERE WasteDisposal IN Waste.MyWasteDisposalChildren

umesh

Thanks very much for reply. I think I was not clear in my first post. My question was, 'How I can show a Table or chart with the rows returned by this query?.'

When I create Query this way, 'Display Results' doesnot show any column.

Do rules support 'grouped by' clause? (Not able to find in documentation). If I write sql query, it is also not showing any columns in 'Display results'. My application require a lot of statistics calculation based on user input like 'total quantity of waste disposed on monthly basis for all waste'
and 'total quantity of waste disposed on monthly basis for a particular waste'

Should I use seperate business object of statistics tables as used in CRM example to show

Regards

Umesh

umesh

I was trying above by using statistics business object as in CRM example. I am facing following issues:

How to capture the process of remocal of object (not reference list)
As clean rule can't take references, I am supplying the references by using clause to another process (where clean is used). The results were ok for initial testing but whether it is ok.

Regards

Umesh