Is it possible to display a list of most recently created pages in Confluence 3.5

[Piergiuliano Bossi]

Hi there,

In Confluence 3.5 is it possible to display a list of most recently created pages? Basically I'm not interested in seeing when a page is updated, but only when it's created.

If not with 3.5, can it be done with any other Confluence version?

Thanks,

bop

[MatthewC · Accepted solution]

There is way.... ;-)

Use some SQL with the SQL Macro plugin from Bob Swift (https://studio.plugins.atlassian.com/wiki/display/SQL/Confluence+SQL+Plugin ) Written for SQL server database

select c.TITLE, c.VERSION, c.CREATOR, c.CREATIONDATE, s.spacekey, s.spacename from
 "Confluence"."dbo"."CONTENT" c,
"Confluence"."dbo"."SPACES" s
where c.spaceid = s.spaceid and 
contenttype='PAGE' and content_status='current'
order by creationdate desc

You can also do it with the Customware Reporting plugin but the load it puts on the server is enough to kill it. here is a version that would work on the current space (I think....but I havent tested it)

{report-block:maxResults=5}
{content-reporter:type=page|space=@self}
  {date-sort:content:creation date|order=descending}
{content-reporter}
{report-body}
{report-info:content:title|link=true} in {report-info:content:space|link=true}, created {report-info:content:creation date}
{report-body}
{report-block}

[Piergiuliano Bossi]

Oh very nice, I'll give a try to the SQL Macro plugin. Thanks.

[Joe Clark]

I don't think this is possible with any of the macros that come included with Confluence by default, but it should be pretty easy to write a user macro to do this!