AEM6.3 group results in Query Builder | Community
Skip to main content
elizabethp60981
elizabethp60981
New Participant
February 25, 2018
Solved

AEM6.3 group results in Query Builder

  • February 25, 2018
  • 3 replies
  • 1365 views

Hi,

I am implementing a search with query builder. I am retrieving content from the last 12 months, but I wish I could group the results per month.

Looking on the internet I could just find grouping to combine more than one search criteria.

Is it posible to group the results by month with query builder?

Thanks in advance

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 aanchal-sikka

It is not possible to group on the month basis.

We would need to execute the query for each months daterange.

Once you have the details of each month, collect the required details in a proper data structure.

Then use this data structure to display/consume results as needed 

3 replies

aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
October 24, 2023

It is not possible to group on the month basis.

We would need to execute the query for each months daterange.

Once you have the details of each month, collect the required details in a proper data structure.

Then use this data structure to display/consume results as needed 

Aanchal Sikka
    Hemant_arora
    Hemant_arora
    New Participant
    February 26, 2018

    SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content]) and s.[cq:lastModified] >= '2013-06-11T14:06:50.197+01:00' and s.[cq:lastModified] >= '2014-06-11T14:06:50.197+01:00'

    ir https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/reference-materials/javadoc/com/day/cq/search/eval/PredicateEvaluator.html

      VeenaVikraman
      VeenaVikraman
      New Participant
      February 26, 2018

      I don't think you can do that, but you can sort it in asc or dsc order. I would suggest you to write a custom code to group your results month wise. After fetching the results of your query, using your back-end code , group them however you want.

        Terms & ConditionsAccessibility statement

        Loading footer...