JQL query: How to see all tickets that had status "In Progress" last month

Question

Hi,

Trying this query to find all the tickets on our Jira board who had status "in Progress" last month with the label frontend

The query I'm using is this:

status changed during (startOfMonth(-1), endOfMonth(-1)) to (In Progress) and labels frontend

With and without the labels query I get No search results found, even though there has been tickets with and without label frontend that have had the status In Progress last month.

fredrikfjetland · Answer

Hi,

Thanks!

The query works, but what I am trying to find is ALL the tickets that visited "In Progress" last month. Today's status for the tickets does not matter.

Does it make sense?

Sanjog Sigdel · Answer

Hi @fredrikfjetland

If you try this query you will get your result:

status = "In Progress" AND updatedDate >= startOfMonth(-1M) AND updatedDate <= endOfMonth(-1M)

Also if you want to get the tickets in Progress for last 30 days below query is the asnwer.

issuetype in standardIssueTypes() and status = "In Progress" and created >= -30d

Do let me know if this works for you.

Thanks

fredrikfjetland · Answer

Hi, thanks!

Both:

(status changed during (startOfMonth(-1), startOfMonth()) to (In Progress))

and

(status changed during (startOfMonth(-1), startOfMonth()) to (In Progress))

give me: "The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it."

while

(status changed during (startOfMonth(-1), endOfMonth(-1)) to (In Progress))

gives me: "No search results found."

when doing this:

(status changed during (startOfMonth(-1), endOfMonth(-1)) to "In Progress")

I get this message: "The Jira server didn't understand your search query. If you entered JQL, please ensure that it's correctly formed. If you entered an issue key, ensure that it exists and you have permission to view it."

So to me it seems like "In Progress" does not work for this query. It works if is just write status = "In Progress". And startOfMonth(-1), startOfMonth() gives me an error message.