AEM Query date range | Community
Skip to main content
K
krist_wang
Level 2
October 9, 2023
Solved

AEM Query date range

  • October 9, 2023
  • 2 replies
  • 779 views

I have a query as below:

 

type=cq:Page
path=/content/ciandtamericaspartnersandboxprogram
tagid=astellas-news:press-releases
tagid.property=jcr:content/cq:tags

property=jcr:content/releaseTime
property.value=2023-10-09T13:44:00.000+08:00

p.limit=-1

 

 

and I want to find all pages under a certain year or month based on releaseTime, Can you help how I need to modify the query ?

 

Best regards!

 

 

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 Mahedi_Sabuj

Hi @krist_wang, You need to use daterange predicate. 

daterange.property=jcr:content/releaseTime daterange.lowerBound=2013-01-01 daterange.lowerOperation=>= daterange.upperBound=2013-02-01 daterange.upperOperation=<=

https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#daterange 

 

 

2 replies

Mahedi_Sabuj
Community Advisor
Mahedi_SabujCommunity AdvisorAccepted solution
Community Advisor
October 9, 2023

Hi @krist_wang, You need to use daterange predicate. 

daterange.property=jcr:content/releaseTime daterange.lowerBound=2013-01-01 daterange.lowerOperation=>= daterange.upperBound=2013-02-01 daterange.upperOperation=<=

https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/querybuilder-predicate-reference.html?lang=en#daterange 

 

 

Mahedi Sabuj
    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    October 11, 2023

    @krist_wang Did you find the suggestions from @mahedi_sabuj helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...