concluído fora do prazo

[Jose Tadeu Rosa Junior]

Bom dia.

Gostaria de uma ajuda.

Como realizar um filtro para saber se o item foi concluído no prazo da data limite,  e também se foi concluído fora da data limite?

Atenciosamente.

[Bill Sheboy · Accepted solution]

Hi @JOSE TADEU ROSA JUNIOR -- Welcome to the Atlassian Community!

How do you know the deadline date?

For example, if this is a date not stored in the Jira issue you could perform this query to find issues completed by the date, such as today's date.

project = myProjectName AND resolved <= "2022-06-28"

To find issues not resolved by the date, or still open, you could use this:

project = myProjectName AND (resolved > "2022-06-28" OR resolved IS EMPTY)

However, if your deadline date is stored in an issue field, such as Due Date, you cannot perform this query with built-in JQL features: it cannot compare two issue fields.  Instead you would need a marketplace addon for JQL or to export the issues to a spreadsheet for comparison.

Kind regards,
Bill

[Jose Tadeu Rosa Junior]

Bom dia, Bill

Muito obrigado pelo feedback, tenha um excelente dia.

Atenciosamente.