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

Piergiuliano Bo

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

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}