Any JQL or Functions can get the open sprint start date or end date?

[jacob cheng]

The idea is to filter out the issues still development status and current date is over development cutoff date (let's say 5 days before sprint end date). anyone has any clue if it is supported at this moment? appreciate it very much

[Nic Brough -Adaptavist-]

You don't need the sprint start and end dates to be able to find these issues.  The sprint is actually irrelevant to this, and saying "this has to be done halfway through the sprint" completely abrogates the point of doing sprints.  If you want to be setting or reporting on a "development cutoff date", then you are micromanaging, and shouldn't be trying to pretend to be Agile.  Scrum is not the right methodology for you because it is Agile.

Your "development cutoff date" is really a "due date", which, in Scrum, is a useful data point for the team to rank their backlog (hey, these four things have a due date that is coming up soon, we should put them at the top of the list).

[jacob cheng]

Agree with your point. In our practice, QA will run full regression at the end of the sprint which normally takes 2-3 days for regression and bug fixing. so there is the agreement between QA and Dev story code check-in has a target cutoff time (soft, not hard) to avoid invalid regression. the query wanted is just like a reminder if these story is not ready yet to testing itself for whatever reason then it is risky to the release quality. hope it explain.

[Nic Brough -Adaptavist-]

So all you really need is "status is (not ready to test) and sprint in openSprints()", and to have your team check the results at an appropriate time.  I'd recommend a dashboard that people check before going into the daily standup, probably during the second half of the sprint.

[Evgenii]

Hi, @jacob cheng 

If you have ScriptRunner, you can make Scripted fields, which return, in issue, dates of its current open sprint.