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

Question

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?

Damon Gaylor_v7l9gn · Answer

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

Pete Singleton · Answer

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