Filters - Linked Issues

Question

Hello,

How does one find all tickets that contain (or do not contain) certain types of linked issues?

For example, lets say ticket ABC-1 has a linked issue "is derived from". How do i create a filter that will allow me to find all tickets that contain the linked issue "comes from"?

Any feedback is greatly appreciated.

mauricio.groth · Answer

Hi @ernesto_davila

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 for all your issues which come from another issue

linkType = "comes from"

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

Rik de Valk (Brainboss) · Answer

Hi @ernesto_davila ,

If by 'parent-child' you mean the Story to Sub-Task relation, and you want to find all Stories that do not have any Sub-Tasks, I think you cannot do that without Apps.

Scriptrunner offers an issuefunction parentsOf where you can provide a sub-query. And you can 'reverse' the query by using the 'not' statement. It would look like this:

issueFunction not in parentsOf("type = Sub-Task") and type = Story

And there are other marketplace apps that offer JQL functions.

Scriptrunner JQL function: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions

JQL Search extensions: https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-the-jql-extensions?hosting=cloud&tab=overview

Have a nice day!

Pramodh M · Answer

@ernesto_davila

How can you know whether the issues is parent or child?