Is it possible to get the data (assignee, time spent) in Work Log JIRA using ScriptRunner

I want to calculate summary the cost rate of each assignee and his time spent on the same issue. Is it possible to do that using groovy script and WorklogManager.

For example:

My rate is $100/hour and another is $150$/hour. We logged work on the same issue. I logged 2 hour and he logged 3 hour. The summary cost for this issue should be: $650.

1 answer

2 votes

Script Runner for JIRA is all about handling issues, so things like worklogs and assignees are always readily available.

For your cost rate stuff, you'll need to do a bit of coding in SR and possibly write add-ons to help with reporting though.  You'll need to decide where you are storing the rates and define how to get to them, then you'll need to think about how you want to get out that $650.  At the most simple level a script-runner scripted field could easily read all the worklogs for time and assignee, mulitply it with a (hard-coded) rate and accumulate them all together, dumping the total on screen, but I suspect you might want more from it than that?


Hi Nic,

Thank you for your answer. I put the rate into Scripted field and I'm able to get that value. But the issue is I don't know how to get the data from Work Log (get assignee and their time spent). I have tried to find on google but no luck. Could you please give me a code example how to do that.

Thanks in advance.

A scripted field has direct access to the issue, so

issue.getAssignee() will return the current assignee

For the worklogs, there may be a better way to do it in a script, but I've used


to fetch the list of worklogs.  You can then iterate over that list using worklog.getAuthor() and worklog.getTimeSpent() to get the owners and numbers out.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,084 views 4 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you