JQL Query for tasks and subtasks in Epic in Filter

[Steven Choiniere]

Hello, 

I have created a filter that holds many Epics (over 200+), and I want to pull a timespent report for all tasks and subtasks within "My Epic Filter"

PLEASE don't say use Scriptrunner, I want a JQL query that can solve this without having to spend an absurd amount of money on a feature Atlassian should have already included. 

Thank you, 

[Jack Brickey]

no JQL option but what about this free option? Not sure if it will meet your needs or not but worth a go...

epic-sum-up-light 

[Jack Brickey]

also, maybe this could be done externally via Excel. you can use the Excel extension to run the query from your Jira project(s) right from excel and then calculate the total time logged.