Advanced searching by date that ticket status is changed to 'In Progress'

[Miho Hayama]

Would it be possible to filter by date that ticket status is changed to 'In Progress' in stead of created date or updated date?

More specifically speaking, I'd like to filter all the relevant tickets that meet both conditions below.

- filter by date that ticket status is changed to 'In Progress'
- filter by month i.e., from 2022/07/01 to 2022/07/31, this way monthly reporting can be done from July, Aug, Sep, and so on..

The JQL I have so far for our project is below:
project = AP and (labels not in (TEST) or labels is EMPTY) and created >= "2022-07-01 00:00" AND created <= "2022-07-31 23:59"

But it's not exactly what I want. I want this to be filtered by date that ticket status is changed to 'In Progress', not by created date. Could you give me an advice, please?

[Walter Buggenhout · Accepted solution]

Hi @Miho Hayama and welcome to the Community!

Yoiu can do history searches like this along the lines of the following:

status CHANGED TO "In Progress" DURING (startOfMonth(-1), endOfMonth(-1))

You can of course replace startOfMonth and endOfMonth with specific dates. The above is a bit more dynamic.

Hope this helps!

[Miho Hayama]

It worked! Thank you so much.