Help with Reporting Plugin query

[ITops123]

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.

• Across all spaces
• Grouped by user
• No need to link to the user profile, as that makes it more expensive

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?

[David Peterson · Accepted solution]

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!

[David Peterson]

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.

[ITops123]

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?