Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!
SOLVED

AEM Query date range

Avatar

Level 3

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

krist_wang_0-1696835537467.png

 

 

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!

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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/quer... 

 

 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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/quer... 

 

 

Avatar

Administrator

@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