Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Not working when Multiple users selected

Phil Darcy _Fibre Repair Team_
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 23, 2023

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 :)

1 answer

1 vote
Trudy Claspill
Community Champion
October 23, 2023

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())

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events