I need some help creating a query using the reporting plugin.
I would like to generate a table that lists the number of blog posts (aka news items) that each user has created in the last 3 months.
The end product would look like this:
||User Name||# of news items created in last 3 months||
|John Doe|14|
|Jane Doe|2|
|etc| |
I am at a loss. Help?
Hi there,
You'll want something like this:
{report-table}
{grouping-reporter:content:creator|as=Creator}
{content-reporter:space=@all|type=news|time=3m}
{text-sort:content:creator > user:name}
{content-reporter}
{grouping-reporter}
{report-column:title=User Name}{report-info:grouped:Creator}{report-column}
{report-column:title=# of news items created in last 3 months}{report-info:grouped:@items > collection:size|format=#,##0}{report-column}
{report-empty}_No blogs posted by anyone in the last 3 months_{report-empty}
{report-table}
Hope that helps!
Indeed there is:
http://www.customware.net/training/atlassian/confluence/confluence_reporting_plugin.html
Not exactly cheap, but it definitely gets you off and running.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks! I made one change to this in order to get more accurate numbers. I changed 3m to 90d for the time parameter.
Question: I love the reporting plugin but am having a hard time teaching myself. Is there a course someone can take to learn more?
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.