Hi all, I'm a newbie in hibernate. I have a question about how to use count() function in DetachedCriteria

Table schema as follow
Member Field plus
jacky aaa 10
jacky bbb 10

I would like to execute the following sql
Select field, count(plus) from transaction where member = ‘jacky’ group by field


How should I do in DetachedCriteria, pls help, thanks very much

DetachedCriteria query = DetachedCriteria.forClass(Transaction.class);
query.setProjection( Projections.projectionList()
.add( Projections.count("plus"))
.add( Projections.groupProperty("field") )
);
query.add(Restrictions.eq("member", "jacky"));
Criteria c = query.getExecutableCriteria(session);
List result = c.list();


see also hibernate reference guide