nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Trudy P Claspill

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?

All comments

Trudy P Claspill

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 P 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 P Claspill . This filter gives the desired result.

Appreciate your help!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql

filter