Filter for issues in only the prior sprint across multiple projects

Holly Schomann
Contributor
August 17, 2021

Hello,

Is it possible to create a filter to identify tickets that are in ONLY the most recently closed sprint across multiple projects? The different boards may have slightly different sprint closing dates.

I tried various versions of the below to no avail.

I appreciate any help you can offer.

Holly

 

Screen Shot 2021-08-17 at 2.29.36 PM.pngScreen Shot 2021-08-17 at 2.30.32 PM.png

1 answer

1 accepted

3 votes
Answer accepted
Bill Sheboy
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.
August 17, 2021

Hi @Holly Schomann 

How about this one, adjusting your timeframe to check Resolved:

project IN (GS, SC, PUB, "CF", ECOM, STU, TCS)
AND sprint IN closedSprints()
AND resolved >= -14d
ORDER BY project ASC, key ASC

Best regards,
Bill

Holly Schomann
Contributor
August 17, 2021

Thanks Bill! 

You will be happy to know that I will be on vacation next week, so I won't be bugging you with any jira questions :-)

Thank you so much again!

Holly

Like Bill Sheboy likes this
Bill Sheboy
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.
August 17, 2021

I am glad to learn that helped you, and I hope that you have a great vacation!

__Bill

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events