Jql query for Parent, user story and subtask

[Omprakash Thamsetty]

Parent Issue : Project

Linked issue: User Story

Sub-Task : Task

I am looking the query to find Parent issue (Project) linked User stories and SubTask.

Hierarchy like below

   Project ID Project summary Project Stauts

       Underneath

    User story ID User story Summary and User story status

Underneath

sub-task ID sub-task summary and sub-task status.

How I can do this query to find project --> User story (Linked to ) --> Sub-task Using jira jql or All-InOne report.

Thanks

[Alexey Matveev]

Hello,

You can not do it out of the box. 

You can use the Structure plugin, which will show the required hierarchy in the convenient way:

https://marketplace.atlassian.com/apps/34717/structure-for-jira-projects-at-scale?hosting=server&tab=overview

Or you can use the ScriptRunner plugin to query such issues:

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_subtasksof

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_linkedissuesof