Query builder get pages that are modified today

[sateeshreddy]

Hi Team, 

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

Any thoughts here?

[aanchal-sikka · Accepted solution]

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

[DPrakashRaj]

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