Roo finder - GroupBy Question

[luthrajat]

Is there a way to generate a group by query
or
Should I use NamedQuery and write my own stuff.

Simple Case Study:

I have an entity having

Date dtStart;
Date dtEnd;
Service service; (Service_Type_1, Service_Type_2,... etc)

I need to get result based on date range and group by service.

[mikej]

You can copy a Roo-generated finder method (found in MyEntity_Roo_Finder.aj) to your main entity class (MyEntity.java), and add the groupings yourself. You'll also want to rename the method it so it doesn't conflict with the Roo-controlled finder method you copied.