ObjectDB Database Search

over result set with setFirstResult and setMaxResults. I could do this with subqueries , however as I understand it from this post: http://www.objectdb.com/database/issue/10, subqueries are not supported by

Subqueries are not support by ObjectDB yet - see this feature request . Getting an OutOfMemoryError ... You do not get the point. I ask a way to subquery in #1. You suggest splitting it into two query in #2. I

As mentioned elsewhere, subqueries are not currently supported.  A subquery is the way that seems recommended to get only the latest entry in a time series (e.g. the latest time-clock entry for all employees).   Is there an ObjectDB way to get the latest entry in a series? 

operator is currently not supported and will be implemented with subqueries  (since its main use is in subqueries ). The following code demonstrates how to use MEMBER OF with parameter for this purpose

system . Subqueries are currently not supported by ObjectDB also for JPA, and could be added to JPA

by ObjectDB. They are listed in the issue tracking system , and unfortunately subqueries

JPQL features are not supported yet by ObjectDB. The main missing feature is subqueries

.7, ObjectDB still doesn't support subqueries ( issue #11 ), map keys ( issue #13 ) and case