Grouping with respect to path returns incorrect result in the querybuilder

Forum|Forum|3 years ago
June 14, 2022
4 replies
892 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by arunpatidar

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

SantoshSai

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-6-5-12-querybuilder-group-daterange/td-p/456054

Regards,

Santosh

Santosh Sai

ShaileshBassi

Author

Community Advisor

I am using AEM 6.5.12 version.

arunpatidar

Accepted solution

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

DEBAL_DAS

New Member

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.

Debal Das, Senior AEM Consultant