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

Question

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.

GanthiRa1 · Accepted Answer

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/querybuilder-predicate-reference.html?lang=en#daterange

Jagadeesh_Prakash · Answer

@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

Sign up

Login with SSO

Login to the community

Login with SSO