I have an object/table Batch with a property organisationId/ORG_ID. There is an Organisation object/table with properties oid/OID and label/LABEL_TEXT. When a batch object is loaded only the organisationId value is loaded not an object of type Organisation. We are using DetachedCriertia to use List<Batch> = dao.findBy(DetachecCriertia). The problem I am having is creating the correct association(s) to sort on the Organisation label. Any suggestions would be very apprecaited.