How to display in confluence stats about time logged in JIRA?

Question

Hi,

First of all, happy new year! ;)

I'd like to get display in confluence the time logged by a specific JIRA user.

I'd only need to get the total number (for all projects) of minutes logged but I need for a single day.

Is that something possible?

Cheers!

Laurent Cantat · Answer

Hi,

Thanks, that's good stuff ;)

Matthew Hunter · Answer

Hi,

Happy (albeit belated) new year to you too. :)

As far as I'm aware, getting Confluence to display specific information about JIRA issues isn't an easy task, but we'll have a shot anyway. The best way to display information about JIRA issues in Confluence is through the JIRA Issues Macro. You can create a search in JIRA along the lines of:

assignee = personx AND created > 2011/01/18 AND timespent != NULL

Click Views->XML and then copy the link, you can then paste that link into the JIRA issues macro and then specify the row 'key' and 'timespent'. You'll then see a table of all of the issues assigned after a certain date, and the amount of time spent per issue.

It's not exactly what you're looking for, but it's a good start. :)

Cheers,

Matt