Issue with JQL Query and the results I am getting

[Terry]

I have created the following JQL Query in Excel using the add in

Project="AOC Court Reporter System"
AND status != Done
OR status != 'Coding Done'

When I run the query to extract my project's "issues" I get all the projects not just mine.

Thanks in advance

[Jason Lane · Accepted solution]

Hi Terry,

Its pretty simple you have the OR option which is why your getting everything. Change the OR to another AND and that will work:

Project="AOC Court Reporter System"
AND status != Done
AND status != 'Coding Done'

Thanks

[Julie d_Antin _Elements_]

I would recommend for the status using "status not in ("Done", "Coding Done") or if you just want to exclude issues that are any type of done/finished status, use the status category: 

statusCategory != Done