How to JQL all issues worked in Sprints from May 2022 through now

[darya_koyfman]

I need to retrieve all issues worked in particular Sprints from May 2022 through now. Is it possible at all?

Thank you!

[Florian Bonniec]

Hi @darya_koyfman 

Have you try something like this ?

Sprint = "You Sprint" and updated >= '2022-05-01' and updated <'2022-06-01'

You may have to update the date format.

Regards

[darya_koyfman]

I need to retrieve all Sprints during 2022 and 2023 (till now). Is it possible without listing all of them?

Is it possible something like this?:

Project = "My Project" AND Sprint ~ "Not all Sprints but only with these letters 'CR' in sprint's name" AND updated between May 2022 and now

[Florian Bonniec]

Hi 

I don' t really know how to achieve that, for sure JQL will never return you the list of sprint as JQL only return issues. So it may be able to return the list of issues that was in the Sprint listed.

To use wildcard you will have to use an app. I've never tested it myself but this one seems to do whar you are looking for.

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3196354728/Text+JQL+functions

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-the-jql-extensions?hosting=cloud&tab=overview

Regards