Date of close issue

Hi All,

we need a custom field which shows the date/time of the close of an issue. I know that the History tab shows the close issue date for each issue but we need the export a report which results the close date for all the issues.

How can we do that?

Thank in advance

Rumi

3 answers

1 accepted

2 votes

Create a Date custom field and capture the current date in the post function of Close transition using the JIRA Suite Utilities plugin (Update Issue Custom Field Value).

Is it a date custom field or a date time field? Did you try both? Also check the version of the plugin. I have used it in the past but not in the latest versions.

Hi Jobin,

somehow it doesn't work:

I insterted %%CURRENT_DATETIME%% but it failed to update the field value.

I didn't find a tutorial for this plugin.


Can you please help?

Hi Jobin,

now it works! Great!

The only problem that it set the field only in now...

do you know asolution which set the custom field in the past transitions also?

You know: the requesters need to do a monthly report tomorrow and needs these infos back from 1 month ago

Thanks again!

Rumi

well, you cant do that with this approach. You will have to find the date and fix it in DB!

how do you mean fix it?

You will have to add an entry for the customfield in the customfieldvalue table.

Hi Jobin,


I discussed with our system admin but he has no idea how to put an entry in the DB.

Can you please hint?

Why "Resolution date" standart field is bad?

That captures the date of resolution. Closed Date is the date when the issue is closed I guess? That is a different transition.

yes, Jobin has right: the resolution date is logged generally when the is RESOLVED.

I need the date captured when the issue is created.

Hi Rumi,

Could you please let me know how you got the post function to update custom field with %%CURRENT_DATETIME%%  work finally?. I added this post function to a transition  to Closed status, but the status did not get updated. I am using On Demand version of JIRA.

 

image2015-6-3 14:40:17.png

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

558 views 3 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you