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; } } }

Need Help with JQL Query

PLaksh11

We have 3 issue types

1.Bug

2. Root cause

3. Non Software

Root cause issue type will be linked with Both (Bug and Non Software) or (Bug or Non software)

Bug and Non software both has same issuelinktype "Causes" with Root cause.

Now i want JQL which gives Root cause ticket which linked with "Bug" only.

I tried below JQL but its giving both BUG and Non software which are linked with Root cause.

project = "Newhw" AND type = "Root cause" and issueLinkType="causes"

Is there any JQL which gives linked issue based on issuetype?

Accepted answers

Trudy P Claspill

Hello @PLaksh11

That is not possible if you have only native Jira JQL functionality available to you.

It is possible with third party apps. Are you willing to consider getting an app that extends the capabilities of JQL?

All comments

Trudy P Claspill

Hello @PLaksh11

That is not possible if you have only native Jira JQL functionality available to you.

It is possible with third party apps. Are you willing to consider getting an app that extends the capabilities of JQL?

Prem_c2ug61

Hi @PLaksh11

As far as I am understanding your query. This is what you should try.

JQL -
Project = "Newhw" AND issuetype = "Route Cause" AND issueLinkType = "causes" AND issuetype != "Non Software"

Trudy P Claspill

Hello @Prem

Your answer is not correct.

@PLaksh11 asked to get a list of only the Root Cause issues that are linked to only Bug issues. Your JQL will provide Root Cause issues linked to any type of issue with the "causes" link.

Prem_c2ug61

Hi @Trudy P Claspill ,

Thanks for the clarification. But then it can be filtered out via issuetype != "Non Software"

Correct JQL - Project = "Newhw" AND issuetype = "Root Cause" And issueLinkType = "causes" AND issuetype != "Non Software"

Prem_c2ug61

Thanks @Trudy P Claspill Have made the necessary corrections.

PLaksh11

Hi @Prem

The Above Query is not working as per expectation. It still shows the Root cause ticket which has Non software.

Hi @Trudy P Claspill

we are using Script runner enhanced Search is it possible to get through it?

Prem_c2ug61

Hi @PLaksh11

Can you share a screenshot of the query result, if possible?

Hannes Obweger - JXL for Jira

Hi @PLaksh11

if you're open to solutions from the Atlassian Marketplace, your use case should be easy to solve 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. You can easily filter your issues by these smart columns, like so:

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.

I should add that JXL can do much more than that: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

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