public class FindEntityByCategoryGroupQuery
extends EntityQuery
Returns the list of "entity" keys possessing the keyedReferenceGroups in the passed category bag.
Output is restricted by list of "entity" keys passed in. If null, all entities are searched.
Output is produced by building the appropriate JPA query based on input and find qualifiers.
NOTES:
1) Category groups are grouped with a logical AND by default.
2) Concerning when the categories are AND'd together - the only way this can be done with a single query was to create a self-join for
each category. If there are a lot of categories, the performance could suffer.
TODO: Test performance with multiple AND'd categories. If too slow, look to process this query in multiple steps.
3) The "orLikeKeys" qualifier complicates matters. The "like" keys are OR'd together and these groups of "like" keys are AND'd together.
As with "andAllKeys", self-joins are created but only one for each group of "like" keys. If none of the keyedReferences passed are alike then this
will reduce to an "andAllKeys" query. If all are alike, then this will query will exhibit the behavior of OR'ing all keys.
- Author:
- Jeff Faath