Hibernate genericDao projection

Question

I'm using Hibernate 4.2.7.Final with Google genericDAO 1.2.0. I'm interested in how can I write a search with group by?

For example:

select a, sum(b) from table group by a

with

Search search = new Search();
search.addFieldGroupBy("a"); //this does not exist, I need something like this
search.addField("b", Field.OP_SUM);

score 1 · Answer 1 · edited Sep 07 '15 at 01:35

1

In hibernate group by query is same as your native SQL other then you will have here your Persistent Object name.

select a, sum(b) from table t group by t.a

edited Sep 07 '15 at 01:35

Mads Hansen

answered Jul 20 '15 at 09:14

Kulbhushan Singh

Sorry, I updated my question, coz I know that this is the query but now I need a Search object for groupping by a field. – KatieAmber Jul 21 '15 at 08:56

1 Answers1