JQL query to select items that moved to Done state not working

[Filipe]

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:

[Walter Buggenhout · Accepted solution]

Hi @Filipe,

Have you tried running the filter without the time part in your dates? So like this:

project = PDN AND issuetype in (Bug, Spike, Story, Task) AND status changed to Done during ("2020-12-01", "2020-12-31") 

[Filipe]

Yup, no joy. Still doesn't return any results.

[Walter Buggenhout]

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 Brickey 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.

[Walter Buggenhout]

It's something I didn't no yet either, but this seems to be related to next-gen indeed. Apparently, history searches are not supported on next-gen. See this related Community thread 

[Jack Brickey]

confounded NG. :-)

that seems like a big hole but verified in my test NG project.

[Filipe]

Thanks Walter. It didn't work. I tried:

1. Expanding the date range

2. Changing the state (just to try the query). And found out this:

- States that return results: Discovery, Implementation, Integration,

- States that DO NOT return anything: 'To Do', Review, Done

[Jack Brickey]

I think we need Atlassian to respond officially with what is/is not supported here. @Filipe I would open a support ticket - Atlassian Support

[Filipe]

Hey Jack, just did open the support ticket as suggested. Thanks for the ideas!

[Filipe]

Atlassian confirmed that this is a known bug... which was opened in 2019. *sob* 

You can see it here: https://jira.atlassian.com/browse/JRACLOUD-72180

[KAGITHALA BABU ANVESH]

hi @Filipe 

i'm getting results for  Server for the below. but for cloud no results 

status changed to Done during (2021-01-01, 2021-01-05)

[KAGITHALA BABU ANVESH]

CHANGED

The "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:

• AFTER "date"

• BEFORE "date"

• BY "username"

• DURING ("date1","date2")

• ON "date"

• FROM "oldvalue"

• TO "newvalue"

(Note: This operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only.)

EXAMPLES

• Find issues whose assignee had changed:

  assignee 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()

• They specified in their documentation , But not working 

[KAGITHALA BABU ANVESH]

[Jack Brickey]

can you try this ...

project = PDN AND issuetype in (Bug, Spike, Story, Task) AND status changed to Done after startOfYear(-1) and status changed to done before endofyear(-1)

[Filipe]

Copy and pasted your query, but no results were returned.

[Jack Brickey]

i haven't played w/ NG much so wonder if there is some limitation. I will try to play w/ it to see how it behaves for me.

[Jack Brickey]

and you are absolutely sure that there are issues that should be returned?