Query for total remaining hours

[Scott Ocamb]

I need a query that will return the issues that will result in the total remaining hours. I use the results to load into excel and do analysis. I need the detail data for my analysis.

My challange is some issues have sub tasks and some do not. So i need a query to return the parent issues with no sub tasks and then the sub tasks with out the curresponsing parent.

This will return me the detailed data without "double counting" the parent issues with sub tasks.

Thanks

[Lucas Lima [Atlassian] · Accepted solution]

Hello,

As commented here, Time Tracking repport may realize the proceed that you want. If you have any doubt about this, please raise a support issue on https://support.atlassian.com.

Cheers,

Lucas Lima

Atlassian Support

[Simon Simon]

Not sure if it will work for you, but you should check out the Time Tracking Report built into JIRA if you haven't already: https://confluence.atlassian.com/display/JIRA/Time+Tracking+Report