Forums

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

JQL search returning result that does not meet query criteria

Jason Brison
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 15, 2011

Doing an advanced search via JQL and I'm getting a result that does not meet my criteria. The query is:

project = Project_Name AND ((status in (Resolved, Closed) AND updated >= -1w) or status = "In Progress" or due <= 1w) ORDER BY assignee ASC, Status ASC

The Issue being returned which shouldn't be was created on 10/Nov/11 12:34 PM, Due on 18/Nov/11 and was last updated:23/Nov/11 4:24 PM and currently has a status of Resolved.

Looking at the above details the issue should not be returned in my search, however the issue has a subtask which does meet the criteria.

Does anyone know if the parent is just being returned becuase the sub-task does meets the criteria?

1 answer

1 accepted

0 votes
Answer accepted
Jason Brison
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 15, 2011

It looks like I was able to fix this with adding a min time to my due date. I think this is a bug but this query seems to fix the issue:

project = Project_Name AND ((status in (Resolved, Closed) AND updated >= -1w) OR status = "In Progress" OR due >= "0" AND due <= 1w) ORDER BY assignee ASC, Status ASC

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events