List all issues in a sprint where the sprint starts with MT

Damon Gaylor September 12, 2019

I'm trying to create a filter so I can share with external customers that will show the future sprints of a project.  The challenge is we have two different teams working from the same projects.  I only want to show issues in future sprints where the sprint name starts with "MT" (the other team is TDS and I want to exclude those).

To future complicate, the backlog filter includes multiple projects.

Here is the current query which works, but does not exclude the TDS sprints:

filter = "Filter for MT" AND sprint in futureSprints() and issuetype in standardIssueTypes() and status != Canceled ORDER BY sprint, rank

I don't see a way to do this, any ideas?

1 answer

0 votes
Pete Singleton
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 12, 2019

We have an add-on called "JQL Functions Collection" which gives us a function called dynamicString().  With this I can do a JQL query like "sprint = dynamicString("VM", "VM") "

Damon Gaylor September 12, 2019

Thanks Pete, I will see if this is available for cloud.

Suggest an answer

Log in or Sign up to answer