Multiple conditions in JQL

[Elie Aouad]

Hi -

My teams are using subtasks and i need to be able to do a Quick Filter for my scrum board for when the following conditions are met:

Subtasks 1, 2, 3 are all set to done

Subtask 4 is in To-Do.

I searched everywhere, but not able to find a good solution.

Thanks in advance for any help.

[Alexey Matveev · Accepted solution]

Hello,

Whare are Sutasks 1,2,3? Are these keys? Issue types?

[Elie Aouad]

Hi -

I am referring to Issue type SubTask under each user story, for example:

UserStory: Create Webpage

SubTasks:

• Coding
• Review
• Test
• Deploy

Trying to do a quick filter to show me all user stories that have Coding, Review and Test in Done State, and Deploy in To-Do. 

You can assume that the summary for each of these subtasks are always the same and repeatable for each user story.

Thanks, i hope that was more clear.

[Alexey Matveev]

Hello,

You would need an add-on to write such a filter.

For example, you could use the JQL Search Extension plugin:

https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira?hosting=cloud&tab=overview

Your JQL query would look like this:

issue in parentOf("issueType in (Coding, Review, Test) and status Done") AND issue in parentOf("issuetype in (Deploy) and status = To-Do")

You can find more info here:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-ParentOf(jql-query)

[Elie Aouad]

Perfect thanks that worked! I used issuefunction in parentOf() i believe it comes with Scriptrunner.