Query to find page and referenced assets list of given date range

[ashok-tech]

Hi, I have a requirement to pull out page and its referenced assets on given date range. Please share the query that help us to generate output. I don't want to write code, I am looking to handle this via query itself. 

[Jagadeesh_Prakash]

@ashok-tech  I don't have the query handy but you can use the ACS report builder to get the report. Refer to below URL's

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/configuring.html

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

[Ganthimathi_R · Accepted solution]

hi @ashok-tech 

You can try something like the below sample query which will get all the pages under specified path that are modified in the specific date range using predicate named "daterange".

path=/content/my-project/en
type=cq:Page
daterange.property=jcr:content/cq:lastModified
daterange.lowerBound=2022-08-10
daterange.upperBound=2022-08-20
p.limit=-1

More options about this predicate can be find here, 

https://experienceleague.adobe.com/docs/experience-manager-65/developing/platform/query-builder/quer...