I've problems understanding how to create a criteria query with related classes and 'or' condition

some pseudo code...


I want to create a query that finds all orders which are related to a customer (e.g. John) either by the deliverTo or the billTo relation.
I don't get how to to this with the criteria api.

I think the Expression.or could do the trick but how to use this with the related classes?

Have a look at Restrictions.disjunction() method. It will be smth. like

DetachedCriteria criteria = DetachedCriteria.forClass(Order.class);
Customer deliverTo = getDeliverToCustomer(); //get your deliver to customer
//same for billTo customer
Disjunction addressRestrictions = Restrictions.disjunction();
addressRestrictions.add(Property.forName("deliverTo").eq(deliverTo))
addressRestrictions.add(Property.forName("billTo").eq(billTo))
criteria.add(addressRestrictions);

See the generated SQL and make sure it is what you want.