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

SOLVED

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

Avatar

Level 1

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. 

1 Accepted Solution

Avatar

Correct answer by
Level 5

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 5

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