Hi, we use DetachedCriteria to construct query dynamically. The query has group by clause. For example

select name, avg(age) from Student where city='NY' group by name;

For a DetachedCriteria with group by, how to get the query result count?

select count(distinct group-by-property) from Student where ...

but there is no API for getting group by properties from DetachedCriteria.

Thanks for help.
Dave