hi Jon, this is not supported at the moment. The only way you can do that is with passthrough SQL. Having said that we have a slot at GSoC where a student will work on the improvement of OQL. Regards Ralf
Is the max function described on http://www.castor.org/oql.html available in the current 1.2 release? I've tried a number of OQL statements (samples below) all of which result in org.exolab.castor.jdo.oql.OQLSyntaxException: An incorrect token type was found near . (found DOT, but expected END_OF_QUERY) Failed OQLs* SELECT max(inviteBatchId) FROM class com.myco.mypackage.Invitation object * SELECT max(inviteBatchId) FROM class com.myco.mypackage.Invitation * SELECT max(object.inviteBatchId) FROM class com.myco.mypackage.Invitation object * SELECT object FROM class com.myco.mypackage.Invitation object WHERE object.inviteBatchId = max(object.inviteBatchId) * SELECT object FROM class com.myco.mypackage.Invitation object WHERE inviteBatchId = max(inviteBatchId) If it is supported any tip on how to select either the full Invitation object with the highest inviteBatchId property value or just highest inviteBatchId itself would be greatly appreciated. Thanks, Jon
