Is there a way to view a list of all pages in a Confluence space, sorted by creation date?

John Trumble

I'm trying to recap activity (specifically page creation) in a given Confluence space within a given time frame.  I've tried to keep track of that separately as pages are added, but I haven't stayed on top of it. 

I know I can see the creation date of any individual page in the space, by looking at the page details.

But can I get a list of all pages in the space, with their creation dates (ideally sortable)?

Thanks!

Dharma Ramos

You could do this via the database. Something like:

SELECT c.title as Page, c.Creationdate, s.Spacename, s.Spacekey
FROM confluence.CONTENT c, confluence.SPACES s
WHERE c.spaceid = s.spaceid AND c.contenttype = 'PAGE' AND c.creationdate BETWEEN '2018-12-01' AND '2018-12-31'
ORDER By c.creationdate ASC;