Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to advanced query a field = "unassigned"?

carlie neff
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 26, 2022

I have an advanced search filter right now that almost gets me what i want to see. I'd like the issues listed to only include unassigned issues and issues assigned to Carlie Neff and Ivers Keller. I need help figuring out how to include the unassigned portion of this.

This language works to include the two users but not the unassigned:

project = "Analysis Lab" AND status != Closed AND assignee = ikeller OR project = "Analysis Lab" AND status != Closed AND assignee = cneff

This language does not work and gives an error:

project = "Analysis Lab" AND status != Closed AND assignee = ikeller OR project = "Analysis Lab" AND status != Closed AND assignee = cneff OR project = "Analysis Lab" AND status != Closed AND assignee = "unassigned"

jira snip.JPG

1 answer

1 accepted

0 votes
Answer accepted
Pramodh M
Community Champion
January 26, 2022

Hi @carlie neff 

Welcome to the Community!!

Try This

(project = "Analysis Lab" AND status != Closed AND assignee = "ikeller") OR (project = "Analysis Lab" AND status != Closed AND assignee = "cneff") OR (project = "Analysis Lab" AND status != Closed AND assignee = EMPTY)

For unassigned issues its assignee = EMPTY

Thanks,
Pramodh

carlie neff
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 26, 2022

Yes! Thank you! EMPTY was the correction i needed. I really appreciate the help.

Like Pramodh M likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events