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; } } }

How to write a JQL to find issues status changed between two dates which include the TIME?

Scarlet Fitness

This questions has been asked but the answers do not include time. The following works but we need to add the time to this jquery and it doesn't seem to work:

status changed during (2019-06-01, 2019-06-20) to (Approved)

Adding time to the date ranges results in an error.

Accepted answers

All comments

Ilya Turov

status changed during ('2019-06-01 10:00', '2019-06-01 12:00') to (Approved)

Jindřich Löffler

Hi, this works well. Thank you.

Please is there a way how to filter by person who made that change ?
I´ve tried "status changed BY (username)" but it will not filter that specific change but any change that was made during task life cycle.

Thank you

NIKHIL KUMAR_0ircd8

Does the dates mention in during refers to the updated Date on the Jira ?

Emily Ewart_309sch

If I wanted to get all Blocked tickets that are at least 3 weeks old, how does the syntax for these fields "(+/-)n(yMwdm)" end up working? Because the below doesn't.

status changed DURING (endOfWeek(), endOfWeek(-3w)) TO (Blocked)

Emily Ewart_309sch

I think it refers to the jira transition date, but not totally sure

Emre Toptancı [OBSS]

The startOf... endOf... functions take parameters in their own units. You don't specify a unit.

In other words:

endOfWeek() means the end of current week,

endOfWeek(-1) means the end of last week,

endOfWeek(-2) means the end of the week before the last,

... so on.

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-cloud