Extract date of state change and save it to a field.

[Soporte Itera]

Hi team, 👋🏻

I hope you are well

I am asking for your support with a problem I am having.😰

How can I extract the date and time that a ticket moved to a status and save that information in a Jira custom field.

[Alejandra Rosales · Accepted solution]

Hi @Soporte Itera!

I've got an idea that might help:

Consider utilizing Jira automation. This involves creating a process triggered by status changes and capturing and storing the date in a specific field. Keep in mind, though, that this will overwrite the field with each status change. Here's the basic structure to give you an idea:

 

{
"fields": {
"Description": "{{now.fullDate}}"
}
}
}

And this would be the final result:

 

Please feel free to adapt it to your preferred field and adjust it as needed to meet your requirements.

If you need more guidance or have further questions, don't hesitate to ask! :-))

Regards,
Alejandra
ServiceRocket Apps Support

[Soporte Itera]

Hi Alejandra,

Thank you very much for your collaboration, the automation works perfectly for new tickets that will barely move to the solved status.

I can ask if this same thing is possible but with old cases, that is, is it possible to extract the exact date of the status change but from the history of the ticket?

Currently the ticket is sent to "Solucionado" and then through the satisfaction survey the customer finalizes the ticket and the automatic resolution is placed, but I would need to extract the date on which the person in charge made the transition to "Solucionado".

[Alejandra Rosales]

Hi @Soporte Itera ,

Absolutely! I've found a solution in this Community Post that helps us capture the date when the issue transitioned to its current state. Just to clarify, this method retrieves the date of the issue's most recent status change, not a specific one.

Here's an example of how to set it up using a manual trigger:

 

{
"fields": {
"Description": "{{issue.statuscategorychangedate.toDate.fullDateTime}}"
}
}
}

 This JSON fetches the date and time of the latest status change. You might explore other triggers, such as scheduling, to automate this process periodically.

Feel free to test it out, and if you need more guidance or have further questions, don't hesitate to ask.

Regards,
Alejandra
ServiceRocket Apps Support