Expand my Community achievements bar.

Adobe Summit 2025: AEM Session Recordings Are Live! Missed a session or want to revisit your favorites? Watch the latest recordings now.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

SOLVED

Grouping with respect to path returns incorrect result in the querybuilder

Avatar

Community Advisor

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.

 

shaileshb501027_0-1655181875155.png

 

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

 

shaileshb501027_1-1655182223482.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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
Arun Patidar

AEM LinksLinkedIn

View solution in original post

5 Replies

Avatar

Community Advisor

Hi @ShaileshBassi ,

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


Santosh Sai

AEM BlogsLinkedIn


Avatar

Community Advisor

I am using AEM 6.5.12 version.

Avatar

Correct answer by
Community Advisor

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
Arun Patidar

AEM LinksLinkedIn

Avatar

Employee Advisor

query-builder.png

 

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.

Avatar

Employee Advisor

Hi @ShaileshBassi ,

 

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