Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments
SOLVED

can we write a query for getting lastmodified date of pages at particular location say /content/abc/xyz

Avatar

Level 1

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 ??

1 Accepted Solution

Avatar

Correct answer by
Employee

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'))]

View solution in original post

0 Replies

Avatar

Level 3

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.

Avatar

Correct answer by
Employee

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'))]

Avatar

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