WAS v8.5 > Develop applications > Develop Dynamic and EJB query > Develop applications that use EJB query > EJB query language > WHERE clauseEMPTY collection predicate
We can use the EMPTY collection predicate to test if a multivalued relationship has no members.
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
Related concepts:
EJB query language
WHERE clause
Related
Use EJB query