JSQL to just list open sprint names across multiple projects

[Jaideep Paidimarri]

JSQL to just list open sprint names across multiple projects.

I am not interested in the stories or issues, but just the sprint names that are active across projects.

[Jack Brickey]

JQL queries resolve to issues. You can include the sprint field as a column.

project = xxx and sprint in openSprints()

[Bill Sheboy]

Hi @Jaideep Paidimarri 

Of note... If you use the above script and decide to export the results to remove duplicate sprint names, when issues have been in multiple open sprints you will get multiple columns in the result set.  Should be easy to prune those down though.

Best regards,

Bill

[Jaideep Paidimarri]

Thanks Jack and Bill.

With JSQL and two  dimension filter I get what I need, but its not in a good format.

I ended up using Sprint Health Gadget for each Scrum board in a dashboard and it served my purpose.