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

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!