Hey guys,
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.
Ian,
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:
Ian,
Please accept the answer if it works for you!
EDIT: I didn't realize this was a discussion, please disregard!
Thanks,
Kian
Recommended Learning For You
Level up your skills with Atlassian learning
Learning Path
Get the most out of Jira
Explore the interface and basic Jira terms, then discover how to effectively manage your work.
Learning Path
Atlassian tools and practices for developers
Focus on your development work by using Jira software features and functions efficiently.
Atlassian Certified Associate
Jira Software Essentials certification
Demonstrate proficiency in utilizing essential Jira features and working efficiently with Agile frameworks like Kanban and Scrum.