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:
Can I do this with JQL only?
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.
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
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
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!
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