Mark Nuttall - 2006-02-17

When I create a query that is an aggregation and I want to use an attribute that is another mapped object, it doesn't work because the object is being used in the select clause and there is no way, that I can see, to only select the value in the select clause that is being group by clause.

so like:

Select sum(sale.product) from Sale as sale group by sale.product

will fail because the select tries to use all the fields from the Product object.

Just wondering if this is being worked on.  Or if I should give it a whirl.