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
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I need to create a JQL filter for the marketing team at my job so that we could pull issues that meet the following criteria:
I have this so far
issuetype = "Monthly Job" AND status in ("1st Proof", "2nd Proof", "Brief Due", "Copy Due", "Final Proof/Complete", "In Progress", "Layout & Design Due", "To Do", "Under Review") AND assignee in (currentUser()) OR (currentUser()) in "Assignee(s))
And the (OR (currentUser()) in "Assignee(s))) part is not working.
Any help would be appreciated
Okay, so this issue that I took a screenshot of is one that fulfills the criteria of the filter I want to create.
If I were one of the "Assignee(s)", say David S, I want to see this issue come up in the filter, even though I'm not the main "Assignee" (system field).
The problem is that I don't know how to make it so that the filter recognizes the current logged on user as one of the "Assignee(s)". That's the one part of the filter that I haven't figured out yet.
However, I did go by your suggestion in making sure that the "Assignee(s)" field is not empty (subsequentially adding [OR "Assignee(s) is not EMPTY] to the JQL), and this seems to work for now. So I appreciate your help with that.
This works for now, but there will be a time where only a few of the users will be in the "Assignee(s)" field for certain "Monthly Jobs" such as SE) Time Punch, where only David S and Phil R would be in the "Assignee(s)" field. I wouldn't want this issue popping up for Gelisa H or Megan C.
I think I understand. So you don't care who the system field "Assignee" is? That could be anybody, but if it is you, you need the ticket to show up?
Try this filter:
issuetype = "Monthly Job" AND status in ("1st Proof", "2nd Proof", "Brief Due", "Copy Due", "Final Proof/Complete", "In Progress", "Layout & Design Due", "To Do", "Under Review") AND (assignee = currentUser() OR Assignee(s) = currentUser()).
This will return for you all tickets that meet the following criteria:
Please accept the answer if it works for you!
EDIT: I didn't realize this was a discussion, please disregard!