Grouping with respect to path returns incorrect result in the querybuilder

[Shailesh_Bassi_]

Hi,

When I try to group the results based on the group and there is a entry for group.1_path and group.2_path it gives me the incorrect result as shown in the image below.

When I do remove the entry for the group without the group.1_path, it works fine

[SantoshSai]

Hi @Shailesh_Bassi_ ,

Can you please tell us which version of AEM are you using? Similar issue found here https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/possible-bug-aem-6-5-8-and...

Regards,

Santosh

[Shailesh_Bassi_]

I am using AEM 6.5.12 version.

[arunpatidar · Accepted solution]

Please try with below sample query

group.1_group.type=cq:Page
group.1_group.path=/content/mysite/de
group.1_group.property=jcr:title
group.1_group.property.value=Test

group.2_group.type=cq:Page
group.2_group.path=/content/mysite/en
group.2_group.property=jcr:title
group.2_group.property.value=Test

group.p.or=true

[DEBAL_DAS]

Long back I had similar requirement with grouping the result with path and multiple properties, the above one I wrote in my code. Hope this will help you.

[milind_bachani]

Hi @Shailesh_Bassi_ ,

Here is a cheatsheet reference which you can use to build and optimise your query :
https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md


Thanks,

Milind