Expand my Community achievements bar.

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