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

Jeroen Rijks_u85t9r

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

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")