How to get data of all closed sprints of multiple projects of a single month in a single jql query?

attaf sheikh

For reporting purpose, i need data of all closed sprints of multiple projects ,month wise, along with issue types mainly of story and tasks. 
I have tried multiple combinations. Closest i have come up is with:
project in ("a","b","c") AND sprint in closedSprints() and issuetype in ("story", "task") ORDER BY created DESC

now i want to limit it only for previous month which is not happening with sprint in (startOfMonth(-1), endOfMonth(-1)) or any other month fields.

 

thanks!

Bill Sheboy

Hi @attaf sheikh -- Welcome to the Atlassian Community!

That is not possible with the built-in JQL features for two reasons:

1. the date information of sprints cannot be queried
2. there is no roll-up feature to perform your month-based reporting

Possible work-arounds depend upon how often you need this reporting and desire to spend money / install addon apps:

• need this infrequently
  • export the issues to a spreadsheet and perform the reporting using spreadsheet functions
• need this often and have money to spend
  • investigate the Atlassian Marketplace for addons for reporting or to add features to JQL
• need this often and do not have money to spend
  • investigate the Atlassian Marketplace for free addons, or
  • add a custom field to issues, set with an automation rule, to include information about the sprint the issue completed during, and use that field with the data comparisons with the built-in JQL

Kind regards,
Bill