JQL query for a status change within the last hour

[Callum Carlile _Automation Consultants_]

I'm looking to find a JQL search for the following condition:

All issues transitioned from In Progress --> Query Raised within the last 24 hours

I've tried many different variations of this, using Atlassian documentation and other answers from the community but have had no such luck. Any help would be greatly appreciated!

[John Funk · Accepted solution]

Hey Callum,

Try this:

project = ABC and status changed from "In Progress" AFTER startOfDay(-1)

[Callum Carlile _Automation Consultants_]

Thanks for your speedy reply John! Unfortunately this didn't work for me, and it is returning zero results. There are also other statuses which In Progress can transition to which I want to be ignored from the JQL - it is only one particular transition I am wanting to query

[John Funk]

Can you share some details about a card that it should have worked for but didn’t? It works fine when I run it. 
Also, you can add changed from to for the status.

[Callum Carlile _Automation Consultants_]

I've just amended the query slightly, from
status changed from "In Progress" to "query raised" AFTER startOfDay(-1) to
status changed to "query raised" AFTER startOfDay(-1).

This is now returning some results, which is great. However it's also returning some results which were last updated yesterday - how can I edit the AFTER startOfDay(-1) part to only return issues within the last hour?

[Bill Sheboy]

Hi @Callum Carlile _Automation Consultants_ 

Please try:  status changed to "query raised" AFTER -1h

Best regards,

Bill

[Callum Carlile _Automation Consultants_]

Worked like a charm, thanks both!

[Bill Sheboy]

I am glad that worked for you, @Callum Carlile _Automation Consultants_ 

__Bill