Filters - Linked Issues

[ernesto_davila]

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.

[Rik de Valk]

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]

Hi @ernesto_davila 

Here's the reference

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-linkedIssueslinkedIssues--

Let me know if this helps 

Thanks,

Pramodh 

[ernesto_davila]

First off, thanks for your feedback!

I believe this is to find linked issues to a certain ticket. essentially, I am trying to identify  tickets with missing parent/child requirements. 

I was able to use "issueLinkType is EMPTY" to find ones that have nothing. This displays all the tickets with no parent OR child requirements. now i want to identify tickets that specifically dont have a parent. and then i will use it to scan for tickets that dont have a child. 

[Pramodh M]

@ernesto_davila 

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

[mauricio.groth]

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