nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Accepted answers

John Funk

Hey Callum,

Try this:

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

All comments

John Funk

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?

jql search.png

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jql