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

Question

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.

Thomas Deiler_db00h3 · Accepted Answer

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

Ignacio Pulgar · Accepted Answer

Hi @prabakar_m ,

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

Best regards