Not working when Multiple users selected

Question

Hi all,

I'm struggling to get quick filter working that includes 9 different assignees with a multiple fields where that individual could be assigned, and i think some of them fields are custom. It also needs to include a specific date range.

My code is as follows:

Project in (REM, CAS, NOC)
AND "Engineer assigned[User Picker (single user)]" in (User1,User2,User3,User4,User5,User6,User7,User8,User9)
OR assignee in (User1,User2,User3,User4,User5,User6,User7,User8,User9)
OR "Request participants" in (User1,User2,User3,User4,User5,User6,User7,User8,User9)
OR "Engineer assigned in remedials (User1,User2,User3,User4,User5,User6,User7,User8,User9)
AND ("Date for Remedials to attend[Date]" = startOfDay()
OR "Date to attend[Date]" = startOfDay())

I know its a little messy but I do have other filters working with most of the above code but with just one user selected.

Any help would be much appreciated :)

Trudy P Claspill · Answer

Hello @Phil Darcy (Fibre Repair Team) Welcome to the Atlassian community. I think the problem is your mixed use of AND and OR. Is it correct to infer that you want to select all issues from the specified projects which also meet the date criteria you specified, and which also match the criteria you have for any of those users being in the specified fields? If so, then try surrounding the entire user criteria block with parentheses; after the first AND and before the AND that precedes the date criteria. >>> and <<< characters added just to point out where those parentheses go. Don't include those characters. Project in (REM, CAS, NOC) AND >>> ( "Engineer assigned[User Picker (single user)]" in (User1,User2,User3,User4,User5,User6,User7,User8,User9) OR assignee in (User1,User2,User3,User4,User5,User6,User7,User8,User9) OR "Request participants" in (User1,User2,User3,User4,User5,User6,User7,User8,User9) OR "Engineer assigned in remedials (User1,User2,User3,User4,User5,User6,User7,User8,User9) ) <<< AND ("Date for Remedials to attend[Date]" = startOfDay() OR "Date to attend[Date]" = startOfDay())