nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Filipe_0w6dbf

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:

Screenshot 2021-01-04 at 16.32.07.png

Accepted answers

Walter Buggenhout

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")

All comments

Walter Buggenhout

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")

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_0w6dbf

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

Filipe_0w6dbf

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.

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

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

KAGITHALA BABU ANVESH_z1zl10

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_z1zl10

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_z1zl10

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud