I am trying to retrieve all items that moved into the Done column on my board.
And I created this query that works correctly for all columns. But never returns anything for Done (and there are plenty of things on that column!).
project = PDN AND issuetype in (Bug, Spike, Story, Task) AND status changed to Done during ("2020-12-01 00:00", "2020-12-31 23:59")
You can see my workflow below:
No, just tested in a test instance of my own and it shouldn't make any difference. So I'm guessing it's either something with the transition to status done (it's not because there are items in that column that they changed to the done status in December) or with the combination of your criteria.
As @Jack suggested, have a look if extending the date range leads to results or leave off the first part of your query to make sure you get some results. There doesn't seem to be anything wrong technically with your query itself.
CHANGED" operator is used to find issues that have a value that had changed for the specified field.
This operator has the following optional predicates:
(Note: This operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only.)
Find issues whose assignee had changed:
Find issues whose status had changed from 'In Progress' back to 'Open':
status CHANGED FROM "In Progress" TO "Open"
Find issues whose priority was changed by user 'freddo' after the start and before the end of the current week.
priority CHANGED BY freddo BEFORE endOfWeek() AFTER startOfWeek()
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events