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

[Michael Riegel]

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

[Ste Wright]

Hi @Michael Riegel 

Just to clarify - what's the need here?

The two JQL queries look to be separate:

• All standard issue type issues assigned to current user, which are open
• All Brief issue type issues assigned to current user, which are open

What join are you looking to make between the two?

Ste

[Michael Riegel]

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.

[Ste Wright]

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]

Thanks @Ste Wright