How do I create a search filter to see all open assignments assigned to me WHERE the brief is open?

Question

Hi,

I've created the following two search filters, but having trouble joining them, since there's no where clause in JQL.

For all open isssues assigned to user= issuetype in subTaskIssueTypes() AND assignee = currentUser() AND resolution = unresolved

For all open briefs opened by user = issuetype = Brief AND assignee = currentUser() AND status = Open

The reason why I want only issues where the brief is open, is oftentimes subtasks aren't closed and it creates clutter in the search results. But if I can filter it for only Open briefs that would help.

Thanks in advance.
Michael

Michael Riegel · Answer

Thanks @Ste Wright

Ste Wright · Answer

Hi @Michael Riegel

Awesome - thanks for clarifying!

It's not possible to do this natively in Jira. What you need is a sub-query for your main query - a little like a "where" function as you mentioned above.

Apps like ScriptRunner or JQL Search Extensions have these more advanced functions.

For example, using ScriptRunner you could have:

issueFunction in subtasksOf("issuetype = Brief AND assignee = currentuser() AND resolution IS EMPTY") AND assignee = currentuser() AND resolution IS EMPTY

^ The sub-query within the parentheses states that only sub-tasks which are children of open Briefs assigned to the current user should be shown.

Ste

Michael Riegel · Answer

I'd like to return only assigned subtasks where the brief is still open.

As I tried to explain above, oftentimes subtasks are left unresolved but the brief is closed (people just don't change the subtask status). Since these subtasks aren't relevant, I'd like to filter them out. The best way I thought to do that would be to join with a query that Briefs must be Open.