Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,780
Community Members
 
Community Events
165
Community Groups

Is there a way to get the date of a status change, not the status category?

Thought I was clever and did a script in Integromat to notify people who still had a status set to a specific kind after two weeks. However it notified someone whose status only changed today. Now I see that even though the previous and current status are different, they're both in the same status category and so the date of status change didn't update. Is there anything that tracks the actual status and not just the status category?

3 answers

1 vote
yuliia_b__SaaSJet_ Marketplace Partner Jun 10, 2021

Hi @Angela Trigg _Quarles_ 

If you're open to using third-party apps, check out Issue History. It's developed by my team to monitor full issues changelog. You can view who and when changed issue statuses.

Snag_3806af1c.png

Hope you find this helpful.

0 votes
Daniel Ebers Community Leader Jun 12, 2021

Hi @Angela Trigg _Quarles_

although I have no experience with Integromat I am wondering how the tool's logic might be.
You surely have seen that you can check for issues longer resting in a status than you want them to be by, for example:
status = "Open" AND status CHANGED FROM "In Progress" TO "Open" BEFORE -14d

More information could be found here:
https://support.atlassian.com/jira-core-cloud/docs/advanced-search-reference-jql-operators/#Advancedsearchingoperatorsreference-CHANGEDCHANGED

Even with an Automation rule you could use this query - so from my imagination the Integromat solution should work together with a query (like the shown above, please adapt it to your requirements) and it should work.

When you say the status changed the query above covers that. Probably there will be the need to review the Integrator documentation, maybe the solution is not capable for using JQL or needs some further specification how the data should be read.
From a Jira's perspective the requirement is one that is seen daily (nothing special).

Regards,
Daniel

0 votes

@Angela Trigg _Quarles_ -

Hi Angela:

In Jira/JSM, WF statuses are associated with 3 categories (TO DO, IN PROGRESS, and DONE).  I am sure you already know that. 

By default, when issues move from status to status, you can find the time via the issue's activity log (i.e. Activity tab).  At our env, we have created custom fields to store the date/time when an issue moves from one status to another status.  However, it depends the need of the users/team - Example:  The team wants to track when an issue moves from Open to In Progress status for project A.  We customized project A's WF on the appropriate transition via post function to capture the date/time when the above event happened.

The drawback of the above implementation is that this need to be done as per individual project  basis. 

Your other two options are - 1) develop custom programs to obtain the status transitions date/time looking at issue's history; 2) research in the Marketplace for possible third party add-ons.

Hope this give you some ideas.  

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Infrastructure Applications Team

Viasat Inc.

Hi Joseph, how did you managed to capture date/time for a transition in post-functions without any Jira add-ons?
Thanks in advance!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Service Management

Jira Service Management Documentation Opportunities

Hello everyone, Hope everyone is safe! A few months ago we posted an article sharing all the new articles and documentation that we, the AMER Jira Service Management team created. As mentioned ...

219 views 0 6
Join discussion

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you