How to calculate time between assignee transitions with JQL?

[philippos]

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?

[Nic Brough -Adaptavist-]

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

Your needs require some scripting or code basically.

[philippos]

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

[Nic Brough -Adaptavist-]

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.

[philippos]

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!

[Nic Brough -Adaptavist-]

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

[philippos]

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