Query builder get pages that are modified today | Community
Skip to main content
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
October 25, 2023

Hello @sateeshkreddy 

 

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

2 replies

DPrakashRaj
New Participant
October 25, 2023

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 

Translate
aanchal-sikka
aanchal-sikkaAccepted solution
New Participant
October 25, 2023

Hello @sateeshkreddy 

 

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
Translate
Aanchal Sikka