Rich Filter-Method to select prior sprint

[Dustin Platter]

Good morning Jira Community.

I have a need to regularly pull the Jira tasks from the prior sprint. However, I have not found any simple process to select from prior sprint. It seems this feature was requested years ago (JSWSERVER-12432) but has not yet been implemented.

I've recently revamped our Dashboards and made heavy use of Rich Filters which provide a great amount of flexibility. Is there a way in which I can utilize Rich Filters to obtain the information I need? We have Rich Filter plugin installed, but I'd rather avoid additional plugins as I'd have to go through corporate for approval and that is an extensive process.

It is very obnoxious to have to go change the filter criteria from Sprint XX to Sprint XY every few weeks. While we typically perform 3 week sprints, that does occasionally change due to holidays, so I'd rather avoid some date based function. Is there any option for me?

[Marc - Devoteam]

Hi @Dustin Platter 

Welcome to the community.

There are no options to do this using JQL or a Rich filters.

There are option, using the Sprint Report on the project or query this in the database

See this KB article, how-to-find-jira-issues-that-belong-to-a-closed-sprint 

Rich Filters are based upon Jira filters, so basically use JQL, they just add extra options to be done on the filer.

[Dustin Platter]

Marc,

Thank you for the response. It's unfortunate that there is no ability for me to capture the information desired for our reporting needs. 

[Marc - Devoteam]

Hi @Dustin Platter 

Then look at getting issue information via the API or marketplace apps that are able to export information to BI tools, like; PowerBI, Tableau, etc...

There you can create your own reports based on combing data in any way you want.

Jira is not a BI tool, it has basic reporting.

Or as you are on DC, you could crate a copy of the DB and query the DB to get the data you want.

I won't suggest to do this on the live DB.