Jira Rich Text Filters

[Ryan Beffa]

I'm trying to create the following rich text filter to exclude 3 Scrum Teams from our project view.  When i search these filters individually I'm able to exclude Scrum individually. However when I try to combine the searches as shown below, it doesn't work. It pulls in all the scrum teams with open bugs.

project = "R3 WFM - Infor" AND issuetype = Bug AND "Scrum Team" != "4 Remaining CBA" AND "Phase Found In" = "Integrated Systems Test (IST)" OR project = "R3 WFM - Infor" AND issuetype = Bug AND "Scrum Team" != "WFM Technical Thing 1" AND "Phase Found In" = "Integrated Systems Test (IST)" OR project = "R3 WFM - Infor" AND issuetype = Bug AND "Scrum Team" != "WFM Technical Thing 2" AND "Phase Found In" = "Integrated Systems Test (IST)"

[Hitesh · Accepted solution]

Hello Ryan,

Try this JQL and let me know if this works for your case.

project = "R3 WFM - Infor" AND issuetype = Bug AND (
"Scrum Team" != "4 Remaining CBA" OR
"Scrum Team" != "WFM Technical Thing 1" OR
"Scrum Team" != "WFM Technical Thing 2"
) AND "Phase Found In" = "Integrated Systems Test (IST)"

Regards,

Hitesh.

[Ryan Beffa]

[Ryan Beffa]

Hi Hitesh, that didn't work, it is still pulling in the teams that I'm trying to exclude. Please see above screen shot.

[Hitesh]

Good to know.

[Ryan Beffa]

I can get it to work when I don't include more than 1 scrum team, but I need to exclude the 3 scrum teams in one filter if possible.

Example of 1 Scrum Team

project = "R3 WFM - Infor" AND issuetype = Bug AND "Scrum Team" != "WFM Technical Thing 1" AND "Phase Found In" = "Integrated Systems Test (IST)"

[Hitesh]

project = "R3 WFM - Infor" AND issuetype = Bug AND
(
"Scrum Team" != "4 Remaining CBA" AND "Phase Found In" = "Integrated Systems Test (IST)"
AND
"Scrum Team" != "WFM Technical Thing 1" AND "Phase Found In" = "Integrated Systems Test (IST)"
AND
"Scrum Team" != "WFM Technical Thing 2" AND "Phase Found In" = "Integrated Systems Test (IST)"
)

Try this and let me know.

[Hitesh]

Or this

project = "R3 WFM - Infor" AND issuetype = Bug AND "Phase Found In" = "Integrated Systems Test (IST)" AND "Scrum Team" not in ("4 Remaining CBA", "WFM Technical Thing 1", "WFM Technical Thing 2")

[Ryan Beffa]

Awesome.. Both of these worked. thanks for your help!!