Query to find page and referenced assets list of given date range | Community
Skip to main content
A
ashok-tech
August 22, 2022
Solved

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

  • August 22, 2022
  • 2 replies
  • 609 views

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. 

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 GanthiRa1

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

2 replies

Jagadeesh_Prakash
Community Advisor
Jagadeesh_PrakashCommunity Advisor
Community Advisor
August 22, 2022

@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

 

    G
    Community Advisor
    GanthiRa1Community AdvisorAccepted solution
    Community Advisor
    August 22, 2022

    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

      Terms & ConditionsAccessibility statement

      Loading footer...