Forming joins with AEM queries using QueryBuilder API
Is it possible to create joins on different node sets when querying AEM using the QueryBuilder API ?
Community Advisor
March 14, 2022
Hi @balaram_rudra, I do not think Query Builder API is supporting JOINs explicitly. At least there is nothing about it in the official Adobe documentation:
- https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en
- https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-api.html?lang=en#morepredicates
As a solution you could use SQL2 - this supports JOINs, here are some examples: https://drfits.com/jcr-sql2-query-with-examples/
You can also try extend Query Builder API developing your own PredicateEvaluator - to meet your requirements using Query Builder.