Hello,


How can I check if a given collection parameter is a subset of an entity's association? For example, imagine we have a Person that has a list of places he/she has visited, namely locations. How can I get a list of persons who have visited an arbitrary list of locations? Something like :collectionParameter is memberOf person.locations. Is this a valid hql query?


Thanks,
Farzad-

you will possibly have to do join the places multiple times. HQL has to be translated in SQL and what you are looking for does not exist as far as I know not in SQL.

How about this one?

select p from Person
where
(select count(*) from p.locations l where l in elements(:collectionParameter)) = :sizeOfCollection


It might not make sense at all because I don't know if expression functions that work on an association would also work on a collection parameter.