How to find the oldest page(s) in Confluence?

Hi,

I want to find the oldest page - the page that was created before the rest. I mean the first page on my Confluence instance.

Also, can I get the list of all the Confluence pages sorted by the creation time in reverse chronological order?

2 answers

0 votes

I think it's fun to work out the SQL query, so here it is:

select * from content where contenttype = 'PAGE' and prevver is null order by creationdate asc;

Hope that also helps!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

ok, I had to watch the database. Found.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.