Search for all sub-tasks under the story status open

[杨简 Evan Yang _ENG - QA - CN_]

How to find all sub-tasks under story status open ，

How to write the corresponding jql

[Trudy Claspill]

Hello @杨简 Evan Yang _ENG - QA - CN_ 

Welcome to the Atlassian community.

If you have only native Jira functionality you cannot create a JQL statement that will find all subtasks based on criteria applied to their parent issue. That would require a third party app. Are you willing to consider a third party app?

[Hannes Obweger - JXL for Jira]

Hi @杨简 Evan Yang _ENG - QA - CN_

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a long list of so-called smart columns that aren’t natively available, including the parent status.

With these, you can model your search in just a couple of clicks, like so:

Once you've narrowed down your list of issues, you can work on these directly in JXL, trigger various operations in Jira, or export them for further processing.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Charlotte Santos -Appfire-]

Hi @杨简 Evan Yang _ENG - QA - CN_ 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to get all sub-tasks under stories in the open status:

issue in subtasksOfParentsInQuery("type = story AND status=open”)

Please contact our support if you have any other questions about this query, or the app in general.

We’ll be happy to help you! 😉