Hello,

I have object with some properties: name, id, category, etc... I want to get all objects but I don't want to get two or more objects with same name property. So, first thing that crossed my mind is distinct, but when using distinct I don't really get my objects, but Strings.

my hql looks like this:

Criteria cr = session.createCriteria("hr.klopa.domain.FoodItem").setProjection(Projections.distinct(Projections.property("name")));

How can I get FoodItem objects distincted by property "name"

FoodItem class looks something like this:

class FoodItem
{
private Long id;
private String name;
.
.
.
// getters and setters...

}

I think you shoud use 'group by name' - it guarantes distinct by name property and you don't have to use projection so you can get objects instead of properties

Yes, that's it. Just what I need. Thank you!