Is it possible to have a jql filter that will only show Stories planned at the start of a sprint

[john.fennell]

hi all

I'm looking to create a filter that will only show Stories planned at the start of sprints.

Can anyone help with this?

[Bill Sheboy]

Hi @john.fennell 

This is not possible with out-of-the-box JQL features.  Assuming no scope changes, the following JQL shows what is in the active sprint:

project = myProjectName and sprint IN openSprints()

I believe there are marketplace addons for JQL which support such queries for sprint scope.  And the built in reports (e.g. sprint report) show the scope at sprint start and end.

A work-around for this need is to create an automation rule, triggered on sprint start, which marks the issues for later reporting.  For example, by adding a label or a value to a custom field, or sending an email with the sprint contents/keys.

Kind regards,
Bill

[john.fennell]

Hey guys,

Thanks for the feedback.

Unfortunatley the company i work for are slow to purchase/use add-ons so it is something i'm going to have to live with.

John

[Trudy Claspill]

Hello @john.fennell 

Can you provide more details on what constitutes a "planned Story"? And is this something you want to run before a sprint is started, after a sprint is started, or after a sprint is completed?

Can you provide more information about the problem you are trying to solve to help us understand your use case?