Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

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!
Oct 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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 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