Criteria: search for two different entity classes...
- by RoCMe
Hi!
I have a "super entity" SuperEntity and three entities ChildEntity1, ..., ChildEntity3 which extends the super class.
It's easy to search for all entities in the database, i.e. we could use
session.createCriteria(SuperEntity.class);
It's no problem to search for one specific entity type, too, just replace the SuperEntity with any of the children to look for entities of that type.
But I have a problem when allowing 'multiple choice' for the types. I.e., it could be neccessary to search all entities of type 1 and 2, but not of type 3.
A first idea was to create two independent queries and join the results in a final list - but that would destroy the paging which uses offset and limit functionality of the database...
Is there a possibility in Criteria to join two different queries in one single result list?
Kind regards,
RoCMe