filter issues assigned to certain user, certain issue type, and current user in user picker cf

[Ian Balas]

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:

• issuetype equals "Monthly Job"
• status can only be : "1st Proof", "2nd Proof", "Brief Due", "Copy Due", "Final Proof/Complete", "In Progress", "Layout & Design Due", "To Do", "Under Review"
• Assignee could be anyone
• current user is selected in a User Picker (multiple users) custom field called "Assignee(s)"

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

[Kian Stack Mumo Systems]

You need to be clear on what you are searching for. 

Assignee(s) = currentUser() is the syntax for looking for where the value of "Assignee(s)" is the current user. 

I'm not sure what exactly you are trying to search for, but if you want the assignee to be Anyone, just not empty, you should use "Assignee is not empty"

[Ian Balas]

Okay, so this issue that I took a screenshot of is one that fulfills the criteria of the filter I want to create. 

• Issue type is "Monthly Job"
• Assignee (system field) is Lauren C
• Assignee(s) (a multi-user picker custom field that I made) listed are David S, Gelisa H, Phil R, Lauren C, and Megan C

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.

[Kian Stack Mumo Systems]

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: 

• issuetype equals "Monthly Job"
• status can only be : "1st Proof", "2nd Proof", "Brief Due", "Copy Due", "Final Proof/Complete", "In Progress", "Layout & Design Due", "To Do", "Under Review"
• Any ticket where the "Assignee" or "Assignee(s)" field is the current user. 

[Ian Balas]

This works perfectly, thank you!

[Kian Stack Mumo Systems]

Ian, 

Please accept the answer if it works for you!

EDIT: I didn't realize this was a discussion, please disregard!

Thanks, 

Kian