JQL query to list out all the story under the epic and sub task of each story

[prabakar_m]

I have created an epic, under that epic I have multiple stories, each story has multiple subtasks.

I want to get the List/Count of a subtask of each story? let me the JQL query

Example: Epic A

Under Epic A has-> Story 1 -> Story 2

Under Story 1 - Sub-task1, Sub-task2

Uner Story 2 - Sub-task1,Sub-task2, Sub-task3

for the JQL query, I have to incorporate it into my JIRA Dashboard. going forward I want to provide my update (status) through my dashboard.

[Ignacio Pulgar · Accepted solution]

Hi @prabakar_m ,

As Thomas suggested, the paretEpic function is what you need here.

Best regards

[Thomas Deiler · Accepted solution]

Dear @prabakar_m ,

first have a look at the advanced JQL function reference. Especially the functions:

• linkedissue
• linkedissue()
• parentEpic()

If this does not help, evaluate the add-on JQL Search Extension.

So long

Thomas