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.