How can I create an issue filter to show all stories related to X ticket including subtasks?

[Christopher Khan]

Hello,

How can I create an issue filter (using JQL) to show all stories related to X ticket including subtasks?  The key piece I am trying to support is how I can include subtasks under the related tickets - not just subtasks under this parent ticket (which is not an epic).

Thank you!

[Pavel Junek]

Hi Christopher,

Welcome to Atlassian Community!

To create an issue filter in JIRA using JQL that shows all stories related to a specific ticket, including subtasks under the related tickets, you can use the following approach:

From Your Company

 Identify the Parent Ticket: Let's assume the key of the parent ticket is X-123.

1. Identify the Parent Ticket: Let's assume the key of the parent ticket is X-123.
2. Use JQL to Find Related Issues and Subtasks:
   • To find all issues that are subtasks of the related tickets, you can use the parent and linkedIssues functions in JQL.

For eg.

parent = "X-123" OR key in linkedIssues("X-123") OR parent in linkedIssues("X-123")

BR

Pavel

[Christopher Khan]

Thank you so much, Pavel!  This did it.  My colleague and I were overcomplicating this as it looked like we were needing to do something utilizing a combination of subTaskIssueTypes and linkedIssues per ticket which we knew was not correct but were unsure how to simplify it as you did.  The use of parent IN linkedIssues looks to be what was missed.

This is what we were originally attempting:

parent = "X-123" OR issue in linkedIssues("X-123") OR (parent = X-234 AND issuetype in subTaskIssueTypes()) OR (parent = X-345 AND issuetype in subTaskIssueTypes())

Thank you so much!