Find linked issues where the linked issue is closed

Question

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

Dan Breyen · Answer

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.

Asher Francis · Answer

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

Hannes Obweger - JXL for Jira · Answer

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