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
