How to get change date in jira search?

[Indranil_Roy]

Hi Team,

I am trying to write a query to extract all the jira related information under a project where status changed from "Team analysis" to "Ready for Development" . I need the changed date to appear in the form of the query below.

This is an example extract columns should contain.

Key

Summary

Status

Created on

Updated on

Resolved on

Changed Dt ( Info required )

Sprint

FixVersion

Please note all the fields apart from the one mentioned in bold are available for extraction. I am not able to track changed dates for activities which had status moved from Team analysis to Ready for development.

For feedback is appreciated.

Regards

Indranil

[Zoryana Bohutska _SaaSJet_]

Hi @Indranil_Roy 

You can try the free version of Issue History add-on.  It will show the date when each Jira item changed status. Behind this data, plugin tracks of all updates that have been made in issues. 

For more deep analysis is the available export.

Hope this helps

Regards

[Indranil_Roy]

Hi @Zoryana Bohutska _SaaSJet_ - Thanks for the update. I will need to check if this add-on is available in our server side. Do you know if there is a method by which we can write query to get the same result.

Appreciate your view on the same.

Regards

Indranil 

[Zoryana Bohutska _SaaSJet_]

@Indranil_Roy 

Excuse me, I haven't mentioned which version of Jira you are using.

Maybe at those discussions, you will find a solution 

https://community.atlassian.com/t5/Jira-Software-questions/JQL-Find-issues-whose-status-changed-during-a-moving-window/qaq-p/1300786

https://community.atlassian.com/t5/Jira-questions/JQL-How-to-write-a-JQL-to-find-issues-status-changed-to-e-g/qaq-p/1328885 

Regards