JQL with WAS NOT status DURING () showing issues created after date range

Question

Hello,

I am using a JQL for graphs this is my JQL :

"Epic Link" = FOO-143 AND Status was not Done during ("2022/06/01", "2022/12/31")

The result shows issues created in 2023 !

Of course these issues where not done in 2022 because they did not exist, but should they be in the result if they did not exist and if so how to exclude them

Since I use this in a JavaScript Chart for JIRA Cloud having time series "sum of existing issues)  adding createdDate < "2023/01/01" doesn't do it for me.

Any advise would be great.

C.heers

Oday Rafeh_2jhprw · Answer

Hi @Corné Aussems

If you're using a graph and want to query for each month separately,

You can use the createdDate filter in each query.

Here's how you can try to modify the JQL queries for each month:

"Epic Link" = FOO-143 AND Status was not Done during ("2022/06/01", "2022/06/30") AND created <= "2022/06/30"

"Epic Link" = FOO-143 AND Status was not Done during ("2022/07/01", "2022/07/31") AND created <= "2022/07/31"

...

"Epic Link" = FOO-143 AND Status was not Done during ("2022/12/01", "2022/12/31") AND created <= "2022/12/31"

By adding the created <= [date] filter for each query, you will exclude issues that were created after the specified date range for each month.

I hope this will solve the issue

Greetings

Oday

John Funk · Answer

You should probably contact the creator of the app then to get their guidance.

Corné Aussems_k9k1d3 · Answer

OFC just including all other statuses do this trick, but then if someone adds one it is not included

"Epic Link" = FOO-143 and status was in (Backlog,"In Progress","In Testing","Waiting for actions")