How to calculate time between assignee transitions with JQL?

Hello,

I use JIRA installed at a customer site so I cannot install plugins or run Java. 

I want to calculate total time each issue was actually assigned to me, so I need to:

  • add time between assignee transitions
  • where assignee is me
  • for all issues

Can I do this with JQL only?

1 answer

1 vote

JQL is for finding issues.  Not reporting the results, or doing calculations on the data found.

Your needs require some scripting or code basically.

Thank you for your answer. Can I create a script or code without deploying anything to the Jira server?

No, you need the script-runner, or another addon that can support scripting, or an addon that implements the reporting you need. However, if you're happy to scrape information, that's easy. Use JIRA's REST interface to run a query for the issues you want, then you can parse, reformat, recalculate and represent the issue data that's returned in any way you want on another machine.

Can you please provide more info regarding this last option? I can manipulate data in Excel or other means. Maybe a relevant exampla? Many thanks!

Well, for Excel, you could start with the excel export of your issue list, but that won't contain much of the data I suspect you need. For grabbing stuff over REST you need a bit of "fetch data" code, but I think you'll get all the data. The obvious place to start is the docs at https://docs.atlassian.com/jira/REST/latest/ but I find them far too "reference material" and much prefer https://developer.atlassian.com/jiradev/api-reference/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-version-2-tutorial and https://developer.atlassian.com/jiradev/api-reference/jira-rest-apis/jira-rest-api-tutorials

Thanks, this option has been blocked by the Jira administrators, so I will keep this for future reference. Thank you

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,734 views 17 21
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