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

[Corné Aussems]

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]

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

[Corné Aussems]

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

[John Funk]

Hi Corné

So why exactly can't you use the createdDate < "2023/01/01"?

[Corné Aussems]

Hi John,

That is because the graph will query per month

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

[John Funk]

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