JQL Filter for Task and Sub-Task with their statuses

Question

Hi Team,

We need JQL filter to get all task and their relevant sub-task with their statuses of particular project like this:

||MAIN ISSUE JIRA ID||STATUS||SUBTASK JIRA ID||STATUS
|Col A1|Col A2|Col A3|Col A4|

Could you please help us on this?

Thanks,

Suchit Kharatmol

João Fernandes · Answer

Hello Suchit,

This is not possible to achieve using issue navigator view.

If you have ScriptRunner for example, you can search for issues that have sub-tasks using

issueFunction in hasSubtasks()

and then you can achieve something like:

but you still can't show the status, because you can have more than one sub-task per issue.

This view you are suggesting you will only be able to have using a report plugin, like eazyBi.

Hope it helps.

Regards,

João Fernandes