Kanban Board Quick Filters Multiple Assignees

[Darren Friedrich]

Hi,

I'm trying to create a quick filter to display all tickets in Kanban board which are NOT assigned to a particular list of assignees.

I have created this JQL query below but it only filters out the first assignee. When I run this query in standard search query box it works. Not sure what I'm doing wrong.

assignee != 61013c157ab149 AND assignee != 5b4632bff2542cd AND assignee != 60460268b6811c AND assignee != 60478c34e22

Thanks!

[Vikram Sathish ASOKAN · Accepted solution]

@Darren Friedrich  Rather than using your search 

you can also use not in within the brackets with each Assignee separated by comas as below 

assignee not in (61013c157ab149, 5b4632bff2542cd, 60460268b6811c, 60478c34e22)

if you have only one assignee you can use the below 

Find all issues that are assigned to any user's Atlassian account id except John Smith's:

not assignee = abcde-12345-fedcba
or

assignee != abcde-12345-fedcba
Find all issues that are not assigned to John Smith's Atlassian account ID

assignee != abcde-12345-fedcba or assignee is empty
Find all issues that were reported by me but are not assigned to me:

reporter = currentUser() and assignee != currentUser()
Find all issues where the Reporter or Assignee is anyone except John Smith:

assignee != "John Smith" or reporter != "John Smith"
Find all issues where the Reports or Assignee is anyone except John Smith's:

assignee != "John Smith" or reporter != "John Smith"
Find all issues that are not unassigned:

assignee is not empty
or

assignee != null

[Darren Friedrich]

Vikram, thank you very much. That has resolved my query. I also noted I was missing an assignee which was throwing me.

[Hamza Chundrigar]

Hi Darren,

Assuming you have the right assignee value IDs, try this JQL Query:

assignee not in (61013c157ab149, 5b4632bff2542cd, 60460268b6811c, 60478c34e22) order by created DESC

Best regards,

Hamza