Task 'DONE' - what is the field in JIRA that I can use to report done card in a given month ?

[Uma Sanjeevi]

Hi 

I am trying to run a query for all DONE cards in a given month - i need to know which date field to use ? 

is it update date or ?

Update date between 1/11/2020 to 30/11/2020 and 

status = done 

[tokcum · Accepted solution]

Dear Uma,

your question might seem simple at first, however it is not in case you need reliable figures. The answer also depends on your workflow.

So let’s start with a simple approach first and elaborate it later.

The most appropriate date field is the resolutionDate.

Status = Done AND resolutiondate >= startOfMonth() AND resolutiondate <= endOfMonth()

I prefer to use the functions startOfMonth and endOfMonth over fixed dates because it is more generic.

You can also refer to the last month with:

Status = Done AND resolutiondate >= startOfMonth(-1) AND resolutiondate <= endOfMonth(-1)

This simple approach fails to provide reliable figures when in your workflow the status Done is not a final state, e.g. a reopen is allowed. In this case it could happen that you report 15 issues done last month and when one of these issues is reopened your counter goes back to 14 issues done.

If this is a problem for your use case you have to model your workflow differently. Don’t hesitate to contact me in case this is of importance to you.

Kind regards,

Tobias

[Uma Sanjeevi]

Thanks - i did it with update date .. since i don't really use Resolution date.. 

thanks for the details - i will update it to use this field

Thanks Tobias