What is the JQL search extension to find out issue which has linked issues?

[Yi Voon Phan]

Hi ,

What is the JQL search extension if to find out issues which has linked issues that are unassigned or unresolved? Thank you. 

[Alexey Matveev]

Hello,

I think you use the JQL Search Extensions plugin. The JQL would be like this:

issue in linkedBy("assignee is EMPTY or resolution is EMPTY")

[Yi Voon Phan]

@Alexey Matveev Hi Alexey, is resolution can be empty? can it be "unresolved" instead? because i tried but unable to find. 

[Alexey Matveev]

Unresolved means empty by default. Some users add the Unresolved option to the resolution list. And you never should do it. If you have such a resolution, then remove it.

[Alexey Matveev]

According to the error you do not have the JQL Search Extensions plugin. Are you sure you installed it?

[Yi Voon Phan]

@Alexey Matveev which plugin are you referring to? need your assistance on this. thanks

[Alexey Matveev]

This one:

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira

You can not get a JQL query, which you want, with out of the box features

[Yi Voon Phan]

@Alexey Matveev, Hi Alexey, I have checked with my admin, it was installed. And not sure why I am still getting the error.

[Alexey Matveev]

Are you on Cloud or Server?

[Yi Voon Phan]

cloud.

[Alexey Matveev]

Try like this:

linkedBy in ("assignee is EMPTY or resolution is EMPTY")

without issue in 

[Yi Voon Phan]

@Alexey Matveev, the JQL is working. But could not search the item I intended to search for. I wanted to search the issue in my helpdesk project. Every ticket submitted by client is linked with internal ticket, with assignee to the issue. But the external ticket that's submitted by client is "unassigned". In this case, how do i have a search extension to trace this external ticket is actually already assigned in the internal issue that is linked with it and already working on by someone. Appreciate your advice on this matter. thank you. :)

[Alexey Matveev]

I am not sure I understood correctly, but maybe you could try:

project = yourproject and assignee is EMPTY and linkedBy in ("assignee is not EMPTY")

 Also I think your internal issues and external issues must have different issue types. You could add this condition there.

[Yi Voon Phan]

@Alexey Matveev i have tried your recommendation but it is not working. 

I tried to use general search and by issuetype as well (as below). Yes, internal and external issue comes with different issuetype. But still could not get this issue searched by my JQL. 

issuetype = "Software - Bug" AND assignee is EMPTY and linkedBy in ("assignee is not EMPTY")

assignee is EMPTY and linkedBy in ("assignee is not EMPTY")

[Alexey Matveev]

Your JQL query will get all issues of Software-Bug issue type, which are unassigned, and has at least one linked issue, which is assigned.