Expand my Community achievements bar.

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

Query builder get pages that are modified today

Avatar

Level 3

Hi Team, 

 

I have a requirement to get the list of pages that have been modified only today.

 

Any thoughts here?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @sateeshreddy 

 

It can be achieved by using

relativedaterange It is an extension of daterange which uses relative offsets to server time. It also supports 1s 2m 3h 4d 5w 6M 7y
relativedaterange.lowerBound Lower bound offset, default=0
relativedaterange.upperBound Upper bound Offset .

 

Example:

relativedaterange.property=jcr:modifiedDate
relativedaterange.upperBound=1d

Aanchal Sikka

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hello @sateeshreddy 

 

It can be achieved by using

relativedaterange It is an extension of daterange which uses relative offsets to server time. It also supports 1s 2m 3h 4d 5w 6M 7y
relativedaterange.lowerBound Lower bound offset, default=0
relativedaterange.upperBound Upper bound Offset .

 

Example:

relativedaterange.property=jcr:modifiedDate
relativedaterange.upperBound=1d

Aanchal Sikka

Avatar

Community Advisor

Hope this helps 

/jcr:root/content//element(*,cq:Page)[(@cq:lastModified >= xs:dateTime('2023-10-25T04:00:00.000-05:00') 

You can change the date as per your requirements