JQL filter for all issues with subtasks & display issues with subtasks display blocked issues if th

Question

Hi all,

I am trying to make filters for my board to A. Display issues with subtasks & B. display blocked issues if the blocking issue is in a "Done" status.

So for A I have:

project = "El Pimpi" AND issuetype in (Story, Task, Bug, Improvement) AND - trying to figure remaining syntax - I don't have scriptrunner and I am on Cloud so some things may not work for me (noticed this with some articles I found)

B  - I found this issuesInQuery="blockedissues" and status=done but doesn't seem to work on cloud.

Any help would be greatly appreciated.

Thanks

mauricio.groth · Answer

Hi @Dean Hoile ,

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

This query will display issues with subtasks:

issue in parentsOfSubtasksInQuery("project = 'El Pimpi'") and issuetype in (Story, Task, Bug, Improvement)

And this query will display blocked issues if the blocking issue is in a "Done" status

linkType = "blocks” and status = done

Check out the documentation for more examples.
I hope this helps!
Maurício

Dean Hoile · Answer

Hi Jack,

Thanks for the welcome and assistance.

I thought this would be the case to be honest from what I had found so far but wanted to see if anyone else had some ideas, and this would be the same if I used  or  JQL Search Extensions for Jira & reports ?

Thanks for your help so far it is very appreciated.

Dean

Jack Brickey · Answer

Hi Dean, welcome to the community.

For your first query unfortunately you cannot easily achieve that. The one option you could consider, though a bit of a hack, would be to use automation and add a label to the parent as soon as the first sub task was added. This would allow you to query for any stories with that label. Of course if one delete all subtasks then the label needs to be removed too. But I think that's a real exception.

For your second query unfortunately again there is not a solution OOTB. Again you could look at some form of automation but this would even be more of a hack IMO.