Filter for remaining days in current sprint

[henny.tse]

When I am using the filters I can filter if remaining estimate for a story is more than a certain # of days (ie. remainingEstimate > 5d), but is there a way to see if the remaining estimate is more than the # of days remaining in the current sprint?

Thank you!

[Trudy Claspill]

Hello @henny.tse 

Welcome to the community.

Filters don't support comparing date/time/duration fields to other date/time/duration fields. And the remaining days in the sprint is not a value that is stored in a field in an issue anyhow.

There might be a method through which you could automatically determine if the remaining estimate exceeds the days remaining in the sprint, and set a true/false field in the issue. You would need to do that calculation each time the remaining estimate value changed. You might be able to do that with an Automation rule, but I have not investigated to see if it can actually be done. The part I am not sure about is whether there is a way to actually get the value for the days remaining in the sprint.

[henny.tse]

Using ScriptRunner Enhanced I was able to use issuefield match filter & regex to see if the remaining estimate was larger than a certain time step but sadly I have not found a way to get the remaining # of days in a sprint.