help with jira query to include time estimates and child story/task count

[p]

Hi Team

Can you suggest me how to get jira query working for

project = abc, type=epic, status=done

result should include

epicid | summary | total estimates time | total spent time | number of child (story/tasks)

thanks

pj

[Nic Brough -Adaptavist-]

The JQL query you need is

project = abc and type=epic and status=done

Queries usually run in the issue navigator, to which you can choose to add fields.  The fields Epic and Summary can be added by default, but the other three you have need to be calculated by code, as Jira does not have them natively.

Do you have one of the scripting/automation Apps available?