JQL for summing up the worklog of all the stories under an epic by giving the epic ID

[Karthik.ss]

JQL for summing up the worklog of all the stories under an epic by giving the epic ID

[Hannes Obweger - JXL for Jira]

Hi @Karthik.ss

welcome to the community!

Just to add to @Valerie Knapp's answer, if you actually want to have your work logs summed up, there would be several apps from the Atlassian Marketplace that can help with that. My team and I work on such an app - JXL for Jira - in which this would be easy to do.

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including the ability to view your issues in their hierarchy, and to calculate sum-ups. With this, you can easily build a view like this:

You can configure different sum-up styles, and sum up any other field, too. 

As said above, there may be other apps that can help with this, too. You may already know that you can trial any app for free for 1 month, and depending on the size of your size, it may be free forever. So if an app is an option for your, perhaps try a few and see which works best for you.

Hope this helps,

Best,

Hannes

[Valerie Knapp]

Hi @Karthik.ss , welcome to the community and thanks for your question.

You could try something like this -

"Epic Link" = SSP-24 AND timespent is not EMPTY

where you put the issue key of the Epic in Epic Link and where timespent has some time in it

If you add the timespent column to your issue results view, in this way you could obtain a list of issues in an Epic where there is time logged.

I hope this helps but if not, please give us your feedback and either I or someone else will try to help.

Cheers

[Madhu_RVS]

Hi @Karthik.ss 

Welcome to the community !!!

If you would be interested in a mktplace app, to get a time estimates/story points roll up of all your child issues upto the parent level and visualize them in a tree view, you can try out our app.

Issue Hierarchy Reports 

Disclaimer : I work for the vendor who built this app