JQL: Get all issues which were InProgress

[Nikolai Mynkow]

I am trying to get all issues which were in progress at a specific date. My first try was:

project = PRJ AND assignee was currentUser() on '2021/09/01'

which gives me the correct results. The only thing I am missing is the status of the issues. But when I add the clause for that there are NO results retuned:

project = PRJ AND assignee was currentUser() on '2021/09/01' AND status was "In Progress" on '2021/09/01'

What are my options using JQL only?

--------

For an acceptable workaround please read the comments

[Jack Brickey · Accepted solution]

It seems that your JQL is accurately formed. Are you sure that you should get results back? Maybe your filter is working and you didn't have any issues assigned to you on that date in that status. As an example here's a quick test Iran

assignee was currentUser() on '2021/09/01' AND status was "In Progress" on '2021/09/01'

And this resulted in three issues returned.

Why don't you try this and see what you get back...

project = PRJ and status was "In Progress" on '2021/09/01'

[Nikolai Mynkow]

project = PRJ and status was "In Progress" on '2021/09/01'

returns no results. And I definitely have issue which were in progress.  

[Jack Brickey]

How confident are your last statement? Can you find an issue and check the history to ensure that's the case?

Another test - find an issue that is currently in progress and use today's date in your JQL and see if it returns that issue.

try removing the project to broaden your search.

[Nikolai Mynkow]

Yeah, I am pretty sure. Is it possible to have a problem with workflows and some kind of mappings? However, I am experiencing this problem in different projects, not a single one.

[Nikolai Mynkow]

@Jack Brickey I have just noticed the response in the browser => 

https://mvcg.atlassian.net/secure/QueryComponent!Jql.jspa

Response:

Status Code: 400

{"errorMessages":["jqlTooComplex"],"errors":{}}

I guess that is the reason why I get an empty page. I am confused...

[Jack Brickey]

Unsure.

can you try something different…a broader date period?

project = PRJ and status was "In Progress" after '2021/09/01'

[Nikolai Mynkow]

@Jack Brickey same error message :(

Maybe I should try the customer support... If any...

[Jack Brickey]

Wait, are you doing this search in the “Advanced search” screen? Can you share a full screenshot w/ the JQL?

[Nikolai Mynkow]

I am trying from all possible places to execute the query, with project, without project, double quotes, single ones, reverse order, different order by and every time I get the same error:

[Jack Brickey]

So either there is a bug or there simply was not any issues in progress during that date period. It is working fine for me so I don’t really suspect it’s a bug but you never know. From the screenshot it appears to be running successfully as it’s giving you the no issues found message. I would strongly recommend finding a specific issue that you know was in a certain status on certain date. This can be found using the history tab. Then run your search around that condition.

[Nikolai Mynkow]

@Jack Brickey I have figured this out. I had to remove the space from the status name:

In Progress => In-Progress

and now everything works as expected. I have tried several other things and it was always the space causing an issue.

What is your status name which you are trying?

[Jack Brickey]

Well yes it is most important to have the correct status name.

[Nikolai Mynkow]

I think you got me wrong here. I had to go to the project settings, edit workflow and rename the status name from "In Progress" to "In-Progress".

It is strange because only that status name had problems with spaces. Every other status with a space works properly.

Anyway, it is not a perfect solution but it is acceptable workaround for me.