How to find linked tickets closed

[WasimBuden]

Hello Community,

I need help with the below-mentioned query, I have two projects A and B set up on JSM as Service desk projects.

We create Linked tickets in Project B from Project A using Jira Misc Workflow Extensions (JMWE) when the ticket in Project B gets closed I need to know so I can close corresponding tickets on Project A.

How can I find linked issues closed in Project B for a Ticket open in Project A? JQL or any other way?

Note: When a ticket gets closed in Project B dont want them to auto close the linked ticket in Project A.

Thanks in advance,
Wasim

[mauricio.groth]

Hi @WasimBuden 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions.

You can use this query to find linked issues closed in Project B for a Ticket open in Project A.

issue in linkedIssuesOfQuery("status = open and project = A") and status = Closed and project = B

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Rahul_RVS]

Hi @WasimBuden 

If you are fine with a mktplace app to get this data, we have created an add-on to track the linked issues across projects,

Issue Hierarchy Reports 

Key features of Links Hierarchy:

• Hierarchy upto 10 levels deep
• Progress % on "remaining estimate" or "original estimates"
• Edit Issue summary, time estimates, story points and assignee on the tree with real time updates in the progress
• Rolled up percentage completion at all levels
• Ability to add/remove the columns on the report

[Mark Segall]

Hi @WasimBuden - There is no native way through JQL.  However, you could do something like this with automation:

• TRIGGER: Issue Transitioned to Closed
• BRANCH on Linked Issues
  Iterates through applicable links
  • CONDITION: Whatever condition you want on each linked issue (project = A, status != Closed, etc.)
  • ACTION: Whatever you want to do with your Project A (Comment, close, etc.)