I have looked at the documentation, but I could not find a similiar example.....

I have a User class and a UserValue class.

User.java

public Set<UserValue> getUserValues();


Now I want to find all users who have a specific UserValue inside their UserValues.

Criteria criteria = _session.createCriteria(User.class);
criteria.add(Restrictions.eq("userValues",someValue)); ???
criteria.setMaxResults(30);
List<User> users = criteria.list();

Currently I am using:

Query query = _session.createQuery("select user from User user,"
+ " UserValue userValue"
+ " inner join userValue.configValue configValue "
+ " where configValue.valueID="
+ configValue.getValueID().toString()";
query.setMaxResults(30);

Maybe this is might help:

List users = session.createCriteria(User.class).createAlias("userValue", "userValue").add(Restrictions.eqProperty("userValue.valueID, configValue.getValueID().toString()).list();

Thanks! I got a:

"could not resolve property: userValue of: User"

...because there is not property getUserValue

only a Set<UserValue> getUserValues() method.

:-(

just checked the docs again....i wish there were more examples forcriteria queries....

There are two possibilities:




The first query uses a table join; the second uses a subquery. The first query allows constraints to be applied to element properties; the second does not.

You may not need the distinct keyword in the first query.

From FAQ

Pls rate if this helped u

Ok My bad
List users = session.createCriteria(User.class).createAlias("userValue", "userValue").add(Restrictions.eqProperty("userValue.valueID, configValue.getValueID().toString()).list();


Change userValue to userValues as your Set within User.class is defined as userValues.

List users = session.createCriteria(User.class).createAlias("userValues", "userValues").add(Restrictions.eqProperty("userValues.valueID", configValue.getValueID().toString()).list();