can we write a query for getting lastmodified date of...

[kritir46532399]

its fairly simple to get the pages under a particular location but i want to get those pages last modified date as well via AEM query.Any idea for the same ??

[ashish_mishra1]

You can Iterate over search results and then adapt the hits to a page and from there get the last modified date of pages. This you can do in Java as well as using groovy script.

[sunjot16 · Accepted solution]

Yes, you can do that.

You can make changes to the following query, as per your use case:

/jcr:root/content//element(*,cq:Page)[(@cq:lastModified >= xs:dateTime('2015-11-03T04:00:00.000-05:00') and @cQ:lastModified <= xs:dateTime('2015-11-03T20:00:00.000-05:00')) or (@jcr:created >= xs:dateTime('2019-01-01T04:00:00.000-05:00')
and @jcr:created <= xs:dateTime('2020-11-03T20:00:00.000-05:00'))]

[kritir46532399]

this will also give the list of page only based on the checking condition. we actually need last modified of the page from query