How to query issues based on the kind of issue type linked to them?

Jayson2 Contreras March 25, 2024

One of our Jira projects have "Test Cases" issue type which has other issue types linked to them like defects, bugs, and other. Now, the we want to search for those "Test Cases" that do not have "Defects" linked to them. Is it possible to do that? Is it possible to make a query based on what kind issue type is linked to it?

2 answers

1 accepted

1 vote
Answer accepted
Hannes Obweger - JXL for Jira
Atlassian Partner
March 26, 2024

Hi @Jayson2 Contreras,

welcome to the community!

Just to add to Stephen's answer: If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the linked issue types, along with many other issue-link-related columns.

This is how it looks in action:

linked-issue-types.gif

As you can see above, you can easily sort and filter by the linked issue types, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

1 vote
Ste Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 25, 2024

Hi @Jayson2 Contreras 

You can't do this natively, as you need JQL to sub-query - i.e. finding all issues related to Test Cases, which are not Defects

You're going to need an App for that, to extend the power of JQL, such as...

Ste

 

Jayson2 Contreras March 25, 2024

Hi, @Ste Wright

Thanks!

I'll try to look into the apps that you mentioned.

Like Ste Wright likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events