Forums

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

AND status changed to "Done" after "-10d" Error

Deleted user April 4, 2019

Trying to get a query that will allow me to filter out stories that have been in the Done status after 10 days.  I have a filter that works, but in the query window has the red X and not the green check.  

project = "Project1" AND issuetype = "Issue1" AND ((status != Done ) OR (status = Done AND status changed to "Done" after "-10d" ))

The query is fine until adding AND status changed to "Done" after "-10d".

I'm trying to understand why the editor thinks it's incorrect but it runs successfully.  

 

JIRA v7.5.2

2 answers

0 votes
Raynard Rhodes
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.
April 4, 2019

What about this query? I figure since the resolution causes finality to an issue you can search for the resolution change (unless your resolution changes more than once)

 

project = "Project1" AND issuetype = Issue1 AND (status != Done OR status = Done AND resolution changed after -10d)
Deleted user April 4, 2019

Thanks for the suggestion.  I tried it but it doesn't seem to filter out the Done entries.  I still see entries with Status=Done and Resolution=Done.

0 votes
Raynard Rhodes
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.
April 4, 2019

When I changed it to only have the () around stats=doneANDstatusChanged it accepts it.

I cannot explain why though.

 

project = "Project1" AND issuetype = Issue1 AND status != Done OR (status = Done AND status changed to "Done")
Raynard Rhodes
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.
April 4, 2019

Or accepts it without an error check.

Deleted user April 4, 2019

Thanks.  That is true, but I'm trying to only filter by date on the Done, so I need those to be bracketed together.

Raynard Rhodes
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.
April 4, 2019

When I used the below code I got a green check-mark with no change in numbers of issues found

project = "Project1" AND issuetype = Issue1 AND (status != Done OR status = Done AND status changed to "Done" after -10d)
Deleted user April 4, 2019

Thanks.  Thie issue is I'm trying to get all the stories that are not in a Done status and only those stories which have been in a Done status within the last 10 days.  Essentially, I want to age out Done stories while still showing all other statuses.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events