JQL query to filter issues in Project A which are linked and replaced by issues in Project B

[Vineet_Kotian]

The project A I am referring to is an old project which has to be retired soon. All of its issues need to be migrated to Project B.

As part of this migration:
1. Project A issues are marked as "Retired" in the status
2. New issues are created in Project B
3. For future traceability, Project A issues are linked to these new issues in Project B under "is replaced by".

I am looking out for a jql filter to search for Project A issues that have not gone through the above process so that I can export them, feed them in a new csv template and bulk import them in Project B all at once.

Please suggest if there are any alternate better options?

[Trudy Claspill · Accepted solution]

Hello @Vineet_Kotian 

You say you want to select issues that have not gone through the process. How do you know which ones have not gone through the process?

Are they in a status other than "Retired"?

Or are then in the "Retired" status but don't have a link to an issue in Project B?

Would one of these issues in Project A ever have a link "is replaced by" to any other issue than the replacement issue in Project B?

[Vineet_Kotian]

Hello @Trudy Claspill 

Thanks for responding.

Yes the issues which have not gone through the process are in statuses other than "Retired" + they wont have a link to an issue in Project B with type "is replaced by".
What they might have is a link to Project C or D with type "relates to" or "Blocks" etc.

The link "is replaced by" is only used to link the replacement issues in Project B and not any other issue or project.

[Trudy Claspill]

project="Project A" and status != "Retired" and (not issuelinktype = "is replaced by" or issuelinktype is empty)

That will get you all issues from Project A that are not in the status "Retired" and that either have not links to other issues or do have links but none of the links are "is replaced by". 

[Vineet_Kotian]

Thats Awesome @Trudy Claspill . This filter gives the desired result.

Appreciate your help!