It would look something like this.
[code]
ExpressionBuilder child1= new ExpressionBuiler(Child.class);
ExpressionBuilder child2= new ExpressionBuiler(Child.class);
ReportQuery subQuery = new ReportQuery();
subQuery.addItem(child1.get("parentid"));
subQuery.setSelectionCriteria(child1.get("propery").equal("firstprop").and(child1.get("value").equal("firstvalue")).and(child1.get("parentid").equal(child2.get("parentid"))).and(child2.get("property").equal("secondprop")).and(child2.get("value").equal("secondvalue"));
ReadAllQuery query = new ReadAllQuery(Parent.class);
Expression exp = query.getExpressionBuilder().get("parentId").in(subQuery);
[/code]
--Gordon
[Message sent by forum member 'gyorke' (gyorke)]
http://forums.java.net/jive/thread.jspa?messageID=268416