How to obtain the date that a task is transitioned?

[Ramos, Dyonata Laitener]

I'm trying to create a Query to extract some metrics, one thing that I need is the date that the user change the task from TO DO do IN PROGRESS, do we have a field to pick up this information?

[Vikrant Yadav · Accepted solution]

Hi @Ramos, Dyonata Laitener  Welcome to Atlassian Community!

You can do this by putting a post function on the transition when issue moving from TO DO to In Progress. 

Put Date time custom field on View Screen and insert post function Update Any Issue Field (JSU) post function and value set as  %%CURRENT_DATETIME%% 

or you have any other plugin like script runner , you can use that as well. 

Thanks

V.Y

[Avinash Bhagawati {Appfire}]

Hi @Ramos, Dyonata Laitener ,

We have raised a request in our Beecom portal, so we can provide quick support and track the progress of the ticket. Please register in our portal and access the ticket using this link: https://beecom-products.atlassian.net/servicedesk/customer/portal/3/JSU-3657 .

And to answer your question,

• You can use the Updated date field for this, although that field is updated on every transition.
• To only track a specific transition the best option is to create a custom field, check this link to get some instructions: https://confluence.atlassian.com/adminjiraserver/adding-custom-fields-1047552713.html .

Then follow the steps:

1. Using JSU app, go to the workflow in question > click on the target transition (for example TO DO to IN PROGRESS: Start Progress)
2. Insert a post function: Update Any Issue Field (JSU)
3. Pick the Issue Field as your custom field and set the Field Value as %%CURRENT_DATETIME%%.

Notes:

• The custom field you created will only track that specific transition and then you can create a Query to extract that metric.
• You can apply that to any transition you want.

Please let me know if you need help to set this into place.

Thanks,

Avinash