JQL - Get all tasks that block any user stories in an open sprint

[Jeroen Rijks]

I want a custom filter to return all Tasks that block a User Story, where both the Task and the User Story are in an open sprint.

This example is almost what I want, but I'm having to update the filter every time I start a new sprint, to manually set the keys of all user stories in my sprint.

project = "My Project " AND issuetype = Task AND Sprint IN openSprints() AND issueLinkType = "blocks" AND issueBlocks in ("TICKET-1", "TICKET-2", "TICKET-3")

I'd like the brackets to automatically contain all user stories in this project's open sprint.

[Laurie Sciutti · Accepted solution]

hello @Jeroen Rijks ~ do you use ScriptRunner?  If so you can use the following:

project = "My Project" AND issuetype = Task AND Sprint IN openSprints() AND issueFunction in linkedIssuesOf("issuetype = Story", "blocks")

[Jeroen Rijks]

Thank you for the advice, I don't have any plugins, and knowing that plugins are needed for this kind of filter was very helpful!

[Kristján Geir Mathiesen]

Hi @Jeroen Rijks and welcome.

Jira out-of-the-box cannot dynamically do this, like you are wanting to. You need a 3rd party app, which will add new functions to JQL, to achieve this. Check out on Atlassian Marketplace - maybe Scriptrunner.

HTH,
KGM

[Jeroen Rijks]

Thank you for the advice

[Charlotte Santos -Appfire-]

Hi @Jeroen Rijks 

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

Unfortunately, using JQL of Jira, 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 find all Tasks that block a User Story, where both the Task and the User Story are in an open sprint:

issue in linkedIssuesOfQuery("project='My project' AND type=Story AND Sprint IN openSprints()", "is blocked by") AND type = Task AND Sprint IN openSprints()

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,

Charlotte