Query by Example with sub Queries ?

angelochen960 · **Joined:** Mon Jul 21, 2008 5:40 am **Posts:** 16

Hi Gurus,

I have two related tables as in the end of this message, and I have a Query by Example:

User u = new User();

// set search conditions in u here

Example example = Example.create(u).enableLike(MatchMode.EXACT);
Criteria cr = getSession().createCriteria(User.class).add(example);

above code works, what I'd like to add now is, the list of Users returned should not be in the Leader table, how to do this? Thanks,

Angelo

public class User {
private Long id;
String Code;
}

public class Leader {
Long id;
private User user;
...
}

mmerder · **Posted:** Mon Feb 23, 2009 8:14 am

Add the following:

Code:

DetachedCriteria d = DetachedCriteria.forClass(Leader.class).setProjection(Projections.property("user"));

cr.add(Property.forName("id").notIn(d));

Rating is welcome ;-)