Query builder get pages that are modified today

Hi Team,

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

Any thoughts here?

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 aanchal-sikka

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

Accepted solution

Community Advisor

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

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

Sign up