Nested query in JQL for free (without ScriptRunner). Is it possible?

[Taras Kobynets]

I need JQL to select issues that have status = "IN QA", and they have linked issues that have status = "OPEN"

[Pierre-Yves]

That is interesting but does not fully answer to the question which mentions a "free" solution

[Mikael Sandberg]

JQL out of the box does not allow nested queries.

The two functions mentioned are from apps, linkedIssuesOf() is available if you have Scriptrunner, and linkedIssuesFromQuery(subquery) is from another app that I do not know the name of. 

[Niranjan]

@Taras Kobynets You can try these JQLs

status="IN QA" and issuefunction in linkedIssuesOf("status=open")

status= "IN QA" and issue in linkedIssuesFromQuery("status=Open")  - may have performance impact depending on the number of results

[Taras Kobynets]

We have added ScriptRunner trial to our Jira cloud (see screen).
Bu I got this error when I try your query (screen2):
issue in linkedIssuesFromQuery("status=open")
Unable to find JQL function 'linkedIssuesFromQuery(status=open)'


Here are more details:
Actually the goal is to highlight (using "card collor" feature of Jira) issues "IN QA" that have linked issues in "OPEN" state. The aim is to visually see on Kanban board if the issue is actually not complately ready for test, because it has linked issues that are still OPEN.

So we were thinking about something like this:
project = "Project1" AND status = "IN QA" and issueLinkType in ("relates to") and issue in linkedIssuesFromQuery(' project = "Project1" AND status = "OPEN" ')

[Mikael Sandberg]

Scriptrunner do not have a function called linkedIssuesFromQuery(subquery), that is why you get the error. You can use linkedIssuesOf(subquery) instead, which comes with Scriptrunner.

[Taras Kobynets]

I feel like I am not sure if ScriptRunner actually activated, because I have this error:

"Field 'issueFunction' does not exist or you do not have permission to view it."

Do you know how I can check of ScriptRunner is active, to be sure?

[Mikael Sandberg]

Go to Settings > Apps > Manage apps and make sure Scriptrunner is listed there and that it is enabled.