I know that the following JQL :
status CHANGED FROM "X" to "Z" AND status = "Z"
gives me all issues i currently need for my report.
However i would like to show the specific date the status changed from X to Z.
In my query result i get 'created date' and 'updated date' but those dates differ from the date the status changed.
Anyone can assist?
you can't get this date with JQL.
If you want to have this for future issues, you can add a custom field to your project and fill this custom field with the current date in a workflow post function of the status change from X to Z. So the date is persisted and you can query it.
As Thomas as mentioned about using post-functions for populating date fields. Similary for all the issues upto now in your JIRA instance if you want to display the transition date then just add the "Scripted field" from the "Script runner" add=on. This will show the date of the transition from older issues as well in the futre issues and this field can be displayed in the issue navigator of the search result.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot