Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,360,197
Community Members
 
Community Events
168
Community Groups

Filters - Linked Issues

Edited

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.
Screenshot 2022-08-28 202205.png

3 answers

1 vote
Rik de Valk Community Leader Aug 28, 2022

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!

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 Community Leader Aug 28, 2022

@ernesto_davila 

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

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

5,011 views 18 31
Read article

Atlassian Community Events