Qual seria a função para um filtro (dinámico) de issue types canceladas dentro da sprint atual?

[Renata Gabardo]

Preciso de uma função para pegar as issues type que foram canceladas dentro da sprint. Estou tentando com a função Open Sprints mas provável que nao esteja funcionando por ser um campo que não se configura uma data.

project = "A" AND Sprint in (openSprints()) AND status in (Cancelado, Canceled, Cancelada) and resolutiondate in (openSprints())

Alguém teria uma ideia para resolução?

Obrigada!

[Walter Buggenhout _ACA IT_ · Accepted solution]

Hi @Renata Gabardo and welcome to the Community!

Unfortunately it is not possible to search for the start or end dates of sprints in JQL. There is a feature request for that type of functionality that you can track here: JRACLOUD-72007 

You can search for issues that changed to a specific status between two dates, but you would have to explicitly mention those dates like this:

Status Changed to "Canceled" DURING("2023/03/01","2023/03/14")

Given that you seem to be trying to find issues in your Open sprints, you may even come close (and maybe even have a more dynamic solution) if you just ignore the dates and use the normal length of your sprints as workaround. Lets assume you use traditional 2-week sprints, you could try the following:

Sprint in OpenSprints() AND status changed to "Canceled" AFTER -14d

This would return all issues in your current sprint(s) that had their status changed in the last 14 days. That would obviously also include issues that were cancelled earlier than the sprint started, but I assume it does not make any sense adding them to the sprint after the sprint start just if they were cancelled earlier on.

Hope this helps!

[Renata Gabardo]

Obrigada pela resposta!! •