nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to capture date of state change in JIRA

Sanjiv Kumar3

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=

Accepted answers

Natalie Hobson

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".

All comments

Rahul Aich [Nagra]

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

In Progress

56d 6h 24m

AAAA

23/Jan/13 2:27 PM

In Progress

Open

AAAA

23/Jan/13 2:27 PM

Open

Resolved

28s

AAAA

23/Jan/13 2:28 PM

Rahul

Natalie Hobson

Sanjiv Kumar3

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?

Nic Brough -Adaptavist-

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)

Jeannette Lamb

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

Sanjiv Kumar3

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

Sanjiv Kumar3

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!

Natalie Hobson

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!

Sanjiv Kumar3

Thank you, this is very useful.

Sanjiv Kumar3

Did you implement to solution?

BMueller

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

Krishna Vemula

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

Ashok Rathore

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.

Neeta Dubey

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

Raman Sagar

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

Jonathan Woo_t8f34g

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)".