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.
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Or accepts it without an error check.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks. That is true, but I'm trying to only filter by date on the Done, so I need those to be bracketed together.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.