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 to create a filter that uses issue and sub-tasks fields together in one query

Sanjay Nanda

For e.g. I want to write a query that shows all subtasks assigned to me that are status!=committed and that have parent issue (for specific fix version & in committed state)

Accepted answers

Tarun Sapra

Are you using ondemand or self-hosted JIRA, as you would need Script Runner plugin for these kind of searches. Script runner plugin is only available on self-hosted.

see here- https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-Subtasks

All comments

Tarun Sapra

Are you using ondemand or self-hosted JIRA, as you would need Script Runner plugin for these kind of searches. Script runner plugin is only available on self-hosted.

see here- https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-Subtasks

Sakthi Balaji

Hi Sanjay,

can you pls try with this JQL QUery in the advance search issues screen

project = "project_name" and status != "ur required status" and issue in subtaskIssuesFromQuery("project = 'project_name' and status = 'ur required status' ")

Sakthi Balaji

You can add assignee ="ur name in the query"

and whatever criteria you wanted in the query

Sanjay Nanda

Thanks Tarun and Sakthi for the reply. I could use Script Runner to achieve this. Below is the query:

issueFunction in subtasksOf("status = Committed") AND status != Committed AND assignee = <loginid>