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.

[sudhakar]

Hi

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 


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

Regards,

Sudhakar

[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

[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!

[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!

[Danyal Iqbal]

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