subquery() ... could create a Query and return that queries expression list
... aka ... where()

// returns the expressionList of the subquery
// ... so you can add any number of criteria to the subquery

ExpressionList<T> subquery() {
     String idPropertyName = ...

     Query<T> subquery = ...
     subquery.select(idPropertyName);

     // id in (select id from MyType where ........)
     in(idPropertyName, subQuery);

     return subQuery.where();

// so we can refer to the 'root' query ...
Query<User> userQuery = Ebean.find(User.class);

userQuery.where().subquery().in("validRoles.name", roleNames);

// we need to add more criteria to the 'root' query (not the subquery)
userQuery.where().ilike("name", "Rob%")

On Sat, Mar 6, 2010 at 5:51 AM, Daryl Stultz <kungfumachin...@gmail.com>wrote: