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

New Participant

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

aanchal-sikkaAccepted solution

New Participant

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

Sign up