JQL for jiras that compares story points and time to end of sprint?

Question

I'm interested in creating a quick filter for 'danger zone' jiras in a sprint. E.g. if story points remaining is 5 (our story points relate to days 1:1) and there are less than 5 (or perhaps 7.5 depending on how 'serious' we want it to be) days left in the sprint then it is shown. Does anyone know of any solution to something like that?

Would be really helpful to see at a glance any jiras that we should prioritise.

Optional extra: Consider time spent on a jira to determine approximate remaining time left on jira and compare that against time til end of sprint.

Lynne Ratcliffe · Answer

Totally understand Matt, unless the request you originally commented on is implemented by Atlassian, we cannot currently work with sprint start and end days (as far as I am aware).  I did try looking at smart values etc, but found nothing.  Hopefully someone may find a way for you. In the meantime I will have a think about it and will let you know if I come up with anything

Matt Kist · Answer

Thanks for the suggestion. The 5 story point jira I mentioned is just an example really. I'm looking for a way for it to be dynamic. I think it would be great to write something like this:

CurrentSprintEndDate - Today < "story points" * {daysPerStoryPoint}

or simply

DaysToCurrentSprintEnd < "story points" * {daysPerStoryPoint}

where  daysPerStoryPoint is a constant, in our case 1.

Lynne Ratcliffe · Answer

Hi @Matt Kist Walter has the right idea, keep it simple. However his filter is less than 5 story points and I believe you are concerned with there being at least 5 story points left. So I would go with greater or equal to 5.

"story points" >= 5