nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Jayson2 Contreras

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?

Accepted answers

Hannes Obweger - JXL for Jira

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:

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

All comments

Ste Wright

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...

ScriptRunner for Jira - you can also get search as a standalone App in Cloud
JQL Search Extensions for Jira
JQL Tricks Plugin
...or another App from the Marketplace

Ste

Jayson2 Contreras

Hi, @Ste Wright

Thanks!

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

Hannes Obweger - JXL for Jira

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.

This is how it looks in action:

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud