I'd like to find issues that are old and most likely out of date. The problem I have is that if I move an issue in my backlog (for re-ordering purposes) the updatedDate gets refreshed.
What I'm basically after is the date when something meaningful happened in the issue, so basically anything except rank changes.
Is this even possible?
You can try to modify this SQL:
Select changeitem.OLDSTRING as Status_was , changeitem.NEWSTRING as Status_new , cwd_user.display_name as Actor_Name , changegroup.CREATED as Change_date , changegroup.* from (Select changeitem.groupid , changeitem.ID from changeitem where changeitem.FIELD = 'status' ) as onlyStatusChange join changeitem on onlyStatusChange.ID = changeitem.ID join changegroup join jiraissue join project on jiraissue.PROJECT = project.ID on changegroup.issueid = jiraissue.ID join cwd_user on changegroup.AUTHOR = cwd_user.user_name on onlyStatusChange.groupid = changegroup.ID where project.pname = '' --enter name of a project and issuenum = 3 --enter issue number here order by --change sort here changegroup.AUTHOR , changegroup.CREATED
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