Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,846
Community Members
 
Community Events
168
Community Groups

Issue with JQL Query and the results I am getting

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

1 answer

1 accepted

0 votes
Answer accepted

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

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
Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

4,964 views 18 31
Read article

Atlassian Community Events