EMPTY collection predicate
To test if a multivalued relationship is empty, use the following syntax
collection-valued-path-expression IS [NOT] EMPTY
Example: Empty collection predicate
To find all departments with no employees
SELECT OBJECT(d) FROM DeptBean d WHERE d.emps IS EMPTY
See Also
EJB query language
WHERE clause
Using EJB query