Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!
SOLVED

Create a report listing all pages by original creation date

Avatar

Level 2

I'm trying to ascertain when pages on my site were first stood up so I can create a report that lists the date each page was created and the URL or puts all those pages in order based on when they were created. I've tried to find the information I need before I posted a question, and I apologize if this is a ridiculously easy item.

 

I would appreciate any information you can share to help me get a data file that sorts the pages based on the original creation date. Thank you in advance for any information you can share!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You can also try with query builder JSON api

http://localhost:4502/libs/cq/search/content/querydebug.html

 

type=cq:Page
path=/content/we-retail
orderby.sort=asc
orderby=@jcr:created
p.hits=selective
p.properties=jcr:path jcr:created
p.limit=-1

 

Screenshot 2023-05-10 at 11.58.43.png

 

JSON QueryBuilder Link will give the json with path and create property



Arun Patidar

View solution in original post

3 Replies

Avatar

Correct answer by
Community Advisor

You can also try with query builder JSON api

http://localhost:4502/libs/cq/search/content/querydebug.html

 

type=cq:Page
path=/content/we-retail
orderby.sort=asc
orderby=@jcr:created
p.hits=selective
p.properties=jcr:path jcr:created
p.limit=-1

 

Screenshot 2023-05-10 at 11.58.43.png

 

JSON QueryBuilder Link will give the json with path and create property



Arun Patidar