JQL Query to Show How Many Tickets Transitioned to "Escalated" Status

[Bell Lopez]

Hello,

Does anyone have any ideas about how to create a JQL query to show all tickets that have been transitioned from a certain status within a certain timeframe? Not sure what JQL parameter to use for specifying a specific timeframe the transition happened in.

For example, we have this right now for seeing if any ticket was transitioned to an "Escalated" status but how could it be modified to specify within the last year or the past month?

(status = escalated OR status was escalated) 

[Francisco Oselame · Accepted solution]

Hello Bella,

To achieve this, you can use the FROM and DURING clause in JQL. The query below, for example:

status changed FROM "In Progress" DURING (startOfMonth(),endOfMonth())

This query will result in all issues that had its status changed from "In Progress" to anything else during this month.

You can then just change this query to match your needs, instead of startOfMonth() and endOfMonth() you can specify the timeframe that you want.

Can you try that and let me know if it works for you?

Thanks,

Francisco Oselame