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
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}
Oh very nice, I'll give a try to the SQL Macro plugin. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.