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 can I create filter of Problems "Closed" without linkedIssues with "RootCause"?

everton-ciandt

Hi there!

I'm newbie in JQL and I have a challenge to create a specific filter in order to get all issues issues (with "Closed" status) without any relationship with LinkedIssues as "RootCause". After my research (google), many players are trying to do the same thing.

I've tried to move deeply on linked issues, but I do not have access on my current Jira environment.

Any ideas how can I create it?

Just to inform, I am not able to install scripts, as I saw in JQLTrick, unfortunately.

Accepted answers

All comments

Danyal Iqbal

You cant do this with the default JQL AFAIK.

You need to install a plugin to do this. (query based on linkedIssues)

everton-ciandt

Hi Danyal Iqbal,

Thanks for your comments.

Could you inform which is the most used to query based plugin?

Any recommendation will be very appreciated.

Thanks!

Jobin Kuruvilla [Adaptavist]

Just FYI, JQL Tricks do not need scripts. They add JQL functions using the JIRA JQL function module. And it does support searching based on linked issues. You might want to do an eval to see if it helps.

everton-ciandt

Thanks Jobin, will try that!

sudhakar_0i9ort

We can get list of linked issues using JQL Search Extensions plugin

JQL : linkedIssueType not in (Roorcuase) AND status = Done which gives you list of which are not linked Rootcause <br>

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-LinkedIssueStatus

Regards,

Sudhakar

Danyal Iqbal

I would recommend script runner or JQL Search extension for jira cloud depending on the budget.

Kristian Walker _Adaptavist_

Hi Everton,

You can achieve your requirement to create a filter of all closed issues which do not have a root cause issue linked to them using the Enhanced Search Page provided by ScriptRunner for Jira Cloud as described here.

You will then be be able to create a JQL search using the linkedIssuesOf() JQL function which is shown in the documentation page located here along with an example of how to use it.

If this answer has solved your issue can you please accept it in order to mark this answer as correct for users who are searching for a similar issue.

Regards,

Kristian

everton-ciandt

Hi Kristian,

Glad to share another plugin, appreciated.

Unfortunately, the Jira environment that I'm using does not have the Script Runner installed.

I've requested to install the plugin to my Jira Admin.
I'll keep this threadup until get the final solution and keep everyone updated.
Thanks.

Kristian Walker _Adaptavist_

Hi Everton,

I just wanted to check in and see if ScriptRunner for Jira Cloud was able to help to achieve your requirement here.

Thanks

Kristian

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

jql

issue-link