You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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 :)
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())
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.