Filtering on children entities

Sources

• https://stackoverflow.com/questions/26684361/filter-child-object-in-spring-data-query
• https://stackoverflow.com/questions/42857947/jpa-with-specification-how-to-filter-an-entity-by-a-child-collection-content
• https://stackoverflow.com/questions/47867124/spring-data-jpa-specification-how-to-filter-a-parent-object-by-its-children-obj
• https://www.baeldung.com/jpa-and-or-criteria-predicates?fbclid=IwAR0vao7fFrB_NghXBEesu-cCFN9HS4WfPcmCXvTkKIvO72sIWu2Nz2aST4A
• https://stackoverflow.com/questions/55629512/how-to-filter-parent-object-which-has-list-of-children-and-a-child-has-list-of-g
• https://tousu.in/qa/?qa=873798/
• https://stackoverflow.com/questions/25627484/how-to-filter-child-entities-collections-with-predicate?noredirect=1&lq=1

Fetch Joins

• https://stackoverflow.com/questions/71840199/how-to-fix-jpa-specification-api-with-join-on-condition-returns-2-query-instead

More detail - Multiselect

• https://www.initgrep.com/posts/java/jpa/select-values-in-criteria-queries

Subquery

• https://stackoverflow.com/questions/53678146/jpa-2-1-predicate-criteria-for-child-entity\

Matching against a list

• https://stackoverflow.com/questions/13940249/jpa-criteria-api-matching-against-a-list-in-spring-data-jpa-specifications

Further Info

• https://stackoverflow.com/questions/47469861/what-is-the-difference-between-a-criteria-a-predicate-and-a-specification