how to capture date of state change in JIRA

Hi -

I am defining a work-flow in JIRA and want to have date fields auto-populate when Issue moves to it's corresponding state. For example, moving an Issue from "In progress -- > Fixed/Checked in", I want to populate a field "Fix date" (with current date) when Issue is moved to "Fixed/Checked-in" state.

Looking forward to experts advise. Thanks in advance.

Best Regards,

=Sanjiv=

8 answers

1 accepted

You can also do this with JIRA Misc Workflow Extenstions using the "Copy value from field to field"; create a custom field called "Fix Date" as per your example, and on the post function copy the value of "Updated" to "Fix Date".

Thanks Nat and Rahul - I appreciate your help. I am still learning about JIRA, so need to try out your suggestions and may have further question. If you have few steps or snapshop that may be handy then please forward to this thread.

Again, thank you very much!

It's pretty simple - once you have the plugin installed, create either a custom date field or date & time field (associate the field with the necessary screens), and on the workflow transition that you wish to capture the data from just add a post function "Copy value from field to field", source field "Updated" and destination field whatever your custom field is. Move the post function to the bottom of your list and publish your workflow. Done! :)

Thank you, this is very useful.

Nat - It worked as expetcetd. Thanks for suggestion.

Jeannette - please review Nat's suggestion if you need any further help then please let me know. It's time for me to "pay it forward".

I followed the above instructions (many thanks to Natalie!) and had a few questions.

Our team's workflow has 4 states: ToDo, InProgress, Ready for Testing, and Done.

Originally, our workflow only had one transition: the one called "Create" that I believe comes out of the box with all workflows. I added 3 transitions.

  • Start Progress = ToDo > InProgress
  • Complete Task = Ready for Testing > Done
  • Complete Task = InProgress > Done

I then added a "copy value from field to field" post function for all 3 transitions where the source field is "Updated" and the destination field is "Start Date" for the Start Progress transition and "End Date" For the 2 Complete Task transition.

In the ideal world, I'd like the Start Date and End Date to populate when the User changes the status to In Progress or Done. However, they currently only update when the User selects the "Start Progress" and "Complete Task" workflows, respectively.

Does anyone have any thoughts on how to accomplish this?

You can have this information by installing the plugin Jira suite utilities. Once installed, go to any issue and click on the transitions tab at the bottom. You should get this kind of information.

Transition Status Change Time Execution Times Last Executer Last Execution Date
Open Open In Progress In Progress
56d 6h 24m
1
AAAA
23/Jan/13 2:27 PM
In Progress In Progress Open Open
9s
1
AAAA
23/Jan/13 2:27 PM
Open Open Resolved Resolved
28s
1
AAAA
23/Jan/13 2:28 PM

Rahul

Thanks Rahul.

So, if I install this utility, would it allow me to define some post functions for my transistion so the date field can get autofilled?

No.

This plugin is simply reading the history of the issue and picking out the dates and dispolaying them. The data is not in a field, it's accumulated from a string of events.

Nat's answer is the one you need if you want an explicit field to store it in (and hence search and use in the same way you use other dates)

If Last Execution date value is available to use in post function it will  make things simple.

All - this is very helpful information - I'm going to challenge you further.

Can we capture the data a custom field changed?

I have a custom field, for brevity, let's call it "Project Priority", and it's a number picker 1-4. I want to know when it was moved up from a 2 to a 1, and then find out how long it stayed unresolved while in that 1 state.

Remember, this is a custom field.

Is there a way to use Natalie's suggestion above for the date a custom field is changed?

Thanks,

Bryant

Hi Sanjiv,

Were you able to find a solution? I too am in need of a way to capture the date and time of each state transition as well as a way to report on them each month. I am curious if you found either of the recommended plugins useful or if you found another solution.

Thank you,
Jeannette

Jeannette - Nat suggested a solution but I need to try out. Once it works for me, I will let you know the steps.

Did you implement to solution?

Sanjiv, were you able to figure out how to create 'Post Function' .. were you able to resolve your original issue?

am trying to do the same, but am stuck up at that point. Creating the 'Post Function...'. any help appreciated

Go to the workflow transition where you want to capture any date in custom field.

Go to Post Function -> Add post function -> Update Issue Custom Field

Select the custom field you want to update.... in description write " %%CURRENT_DATETIME%% "

This should capture the date the transition was made.

Ashok, Can this be done in JIRA Cloud? Because there isn't any post function called Update Issue Custom Field, I can find only Update Issue Field. Please see the image below.

Thanks

image2016-10-17 14:57:15.png

After reading this and trying it, I found the same issue as you.

The "Update Issue Custom Field" is functionality provided by the "Suite Utilities for JIRA (JSU)".

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,317 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot