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

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'