Advance search showing too many results

Question

Hi, im trying to list all 'open', 'in progress' or 'to do' jiras that were raised by specific users, under a a few projects.
However the attempts I make using the advance search always shows more then the required Jira (for example 'closed' jiras) Even if I exclude these from the search using the AND status =! closed

Any help would be great..

Here is the search im using...

Project in ("PITstop Bugs", "Business Merlin - Not Prioritised", "PITstop Merlin & Web") AND issuetype in (bug, story, spike, "Change Requests") AND reporter = Harry.Heiskanen OR reporter = Paul.Ballard AND status = "To Do"

Ravya · Accepted Answer

Hi @Paul Ballard ,

Welcome to Atlassian Community!

Try this JQL, may be it will help:

Project in ("PITstop Bugs", "Business Merlin - Not Prioritised", "PITstop Merlin & Web") AND issuetype in (bug, story, spike, "Change Requests") AND reporter in ("Paul.Ballard",Harry.Heiskanen") AND status = "To Do"

--Ravya

Anton_Ermolaev · Accepted Answer

if you use only 'open', 'in progress', 'to do' and 'closed' statuses in your workflow, than your JQL would be something like that:

Project in ("PITstop Bugs", "Business Merlin - Not Prioritised", "PITstop Merlin & Web") AND issuetype in (bug, story, spike, "Change Requests") AND reporter in (Paul.Ballard,Harry.Heiskanen) AND status =! Closed