How can I find issues I moved?

I have two projects with similar names. One of the projects wanted to update the issuetypes. I moved a couple hundred issues from one issue type to another in that project. How can I search for those issues to move them back.

I tried updatedDate but that did not work

Atlassian isn't going to do to search by updated by.

Please help...

1 answer

1 accepted

Try using "updated = "date of move" " instead updatedDate.

 There is a small difference between creator and author. I do not remember exactly, but if somebody created an issue and another moved it then these fields will be different.

JQL does not allow to compare two user fields, since you can export it into excel and find there issues where these fields are diffrent. Then use "issuekey in ()" to get it all.


Thanks..I should have mentioned I tried that as well. Doesn't look like moving an issue from one type to another constitutes an update.

It is time for hardcore solution! Here is an SQL to get issues for which issue key was changed (it means, it were moved) Select project.pkey + '-' + cast(jiraissue.issuenum as varchar(20)) as issueKeyForJQL , jiraissue.issuenum , changeitem.* from jiraissue join project on jiraissue.PROJECT = project.ID join changegroup join changeitem on changegroup.ID = changeitem.groupid on jiraissue.ID = changegroup.issueid where project.pkey = 'PR197' --type your project key here and changeitem.FIELD = 'Key'

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,739 views 11 18
Join discussion

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot