Find linked issues where the linked issue is closed

[Asher Francis]

Hi there

Some background first... we have a support team who escalate issues to development. When the support team in Jira Service Management change the status to "Requires development", it creates a ticket in the Jira Software project owned by the developers, and links the tickets together.

Due to limitations with multi-project rules, we have not yet implemented a rule to close the support ticket when the development ticket is closed.

So we are in a situation where we have a number of support tickets are open, where the linked development ticket in Jira Software is closed.

I need a JQL query to find all of these tickets, where the Linked tickets have the link status of "relates to"

So for hypothetical purposes, let's say the support project is called "IT" and the dev project is called "DEV"

Find all the unresolved tickets in project IT, where they have a linked ticket "relates to" in project "DEV" where that linked ticket is closed.

I know what I need, I just don't know how to translate it into a JQL search!

Thanks in advance

Asher

[mauricio.groth]

Hi @Asher Francis

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all your unresolved tickets in project IT, where they have a linked ticket "relates to" in project "DEV" where that linked ticket is closed.

issue in linkedIssuesOfQuery("project = DEV and linktype ='relates to' and status = closed") and project = IT and status != Closed

Please contact our support if you have any other questions about this query.

We’ll be happy to help you!
Best regards,
Maurício

[Hannes Obweger - JXL for Jira]

Hi @Asher Francis

I understand that you're looking for a JQL query, but I thought you might find this direction interesting, too:

My team and work on an app named JXL for Jira, a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields. It also comes with various advanced features, including support for configurable issue hierarchies; these can be based on Jira's built-in parent-child relationships, or based on issue links. With this, you could easily build a report that shows your IT tickets along with their related DEV tickets, like so:

As JXL will sort out the parent/child relationships for you, you can simply pull in all open tickets from IT all closed tickets from DEV, and hide all issues without children or without parent (that's one click, each). Once you have your list of issues, you can work on your issues directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export your issues to Excel or CSV.

Any questions just let me know,

Best,

Hannes

[Dan Breyen]

I'm not answering your question per se, but I was able to create an automation rule in JIRA that notifies the assignee of the linked JSM Service Request.  So the Assignee gets notified that the bug was fixed.  Maybe that helps for future use.

You might be able to use the "issueLink" JQL field to get your query.

Advanced search reference - JQL fields | Jira Software Cloud | Atlassian Support

[Asher Francis]

Thanks Dan! I am setting up the automation now, which we couldn't do before as we had JSD standard so were limited on multi-project automation. We're on premium now so I can enable it.

Thanks for the link - I need to be able to do this without a third party addon

[Dan Breyen]

It takes a little practice, and Support should be able to help you out w/ the automation if you get stuck, (they've helped me on them). I agree about not using the third party addon.  It almost feels like commercials on the community pages.