How to use Advanced Search to list all the Story that pending on the significant sub-tasks?

[Yiling Dai]

We have many stories under 1 project, for each story, there are 5 sub-tasks, what would be the JQL like if I want to list all the stories which are pending on the significant sub-tasks?

e.g. 

For Storya, I have :

task_1_Storya; task_2_Storya; task_3_Storya; task_4_Storya; task_5_Storya.

For Storyb, I have:

task_1_Storyb; task_2_Storyb; task_3_Storyb; task_4_Storyb; task_5_Storyb.

And we have Storyc, Storyd...with the same structures.

Now I want to list all the stories which have task_1 completed but task_2 not completed, 

is anyone aware of how to create the JQL?

[Trudy Claspill]

Hello @Yiling Dai 

Welcome to the community.

Jira does not natively have functionality to support the filter you want to create. You will have to look for a third party app that can extend the Jira functionality to support your needs.

[mauricio.groth]

Hi @Yiling Dai 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all he stories which have task_1 completed but task_2 not completed

issue in parentsOfSubtasksInQuery("status = done") and issue in parentsOfSubtasksInQuery ("status != done") and type = Story

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício