I ve been blown away by how neat Appfuse is and its been a great kickstart.

I m trying to ensure that duplicates are removed from the data returned by
hibernate by forcing a group by - So far I ve tried to use the Projection
group property on the criteria as follows:


criteria.setProjection(Projections.projectionList().add(
                                        
Projections.groupProperty("landlord_details").as(
                                                        
"landlord_details")).add(
                                        
Projections.groupProperty("landlord_agent_details").as(
                                                        
"landlord_agent_details")));



However this no longer returns all the data I need and only returns the
columns which I have grouped by which is wrong :(

Can anyone give a pointer on how to force a group by on certain columns
whilst still keeping all the other columns that I need?




-- 
View this message in context: 
http://www.nabble.com/Forcing-A-Group-By-In-Hibernate-tp19453450s2369p19453450.html
Sent from the AppFuse - User mailing list archive at Nabble.com.

Reply via email to