Hi all !

I have a doubt about a criteria that I did.

This is the code that I need.

select
sum(table_name.field_1)
from
Table As table_name
group by
table_name.field_2

When I use the "group by" clause, NHibernate put the field_2 on my "Select".

I just want like above.

Thanks

Thiago (from Brazil)

Anybody can help me please ?

Nobody understand my doubt ?

I made a issue / patch for something like this in the Criteria API for Hibernate Core. See if you can take something from it?

Criteria api does not allow a groupProperty to _NOT_ be included in the selected columns
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2893

Basically it allows you to specify a groupProperty like this:

Javadoc:

Ok ....

I understood it. Thanks by your help.

Bye.

Best regards.

Thiago (from Brazil)