Sum of worklogs for EPIC and its structure

Roman Kvasňa

Hi, I have concrete EPIC.

Epic has worklogs and subtasts with worklogs. There are some stories and spikes connected to Epic using Epic Link. Each story or spike has its own worklogs and has subtasks (Technical task (Generic)) with worklogs.

Is there any possibility to get sum of all worklogs in this structure using JQL?

Thanks a lot

Roman

Hannes Obweger - JXL for Jira

Hi @Roman Kvasňa

welcome to the community!

I'm not aware of a built-in solution for this; to the best of my knowledge, you'll need extra tooling. A few directions forward:

• You can always export your issues to Excel or CSV and perform some kind of post-processing. Obviously, this is gonna be quite a bit of work.
• If you have Jira Automation, you could try performing the sum-up in an automation rule and storing the result on the epic. Since there's a few levels of hierarchy involved, I'd assume this to be quite tricky, if at all possible. Perhaps someone else can lean in here.
• You will find solutions for this in the Atlassian Marketplace. Since you've tagged your question for Jira Server: As you may have heard, apps sales have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that; you'll have way more options. This being said, I myself work on an app that would solve your use case very easily, and that is still available for Jira Server (as well as for Data Center or Cloud, of course); I'll provide more details below.

Hope this helps,

Best,

Hannes