Expand my Community achievements bar.

July 31st AEM Gems Webinar: Elevate your AEM development to master the integration of private GitHub repositories within AEM Cloud Manager.
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

View solution in original post

5 Replies

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

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