How to calculate time between assignee transitions with JQL?

Question

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?

philippos · Answer

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

Thank you

Nic Brough -Adaptavist- · Answer

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 · Answer

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!