Forming joins with AEM queries using QueryBuilder API

[Balaram_Rudra]

Is it possible to create joins on different node sets when querying AEM using the QueryBuilder API ?

[lukasz-m]

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/quer...
• https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/quer...

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.

[Balaram_Rudra]

Thank you @lukasz-m . I wanted to try SQL2 queries however these query results are not pagination friendly when compared to Query Builder. I will try and implement custom predicates for joins