Problem with Status CHANGED date query

[Vineet Sawhney]

Hi guys,

The below working fine in one Jira instance (company) but not working properly for the other instance. 

status changed before startOfDay(-5) AND createdDate <= startOfDay(-5)AND resolution = Unresolved

Does anyone else face this problem?

[Jack Brickey · Accepted solution]

what are you experiencing exactly. what is being returned?

I am not experiencing issues on my instance.

[Vineet Sawhney]

Hey Jack, I'm seeing tasks where the status was changed a day back instead of 5 days and prior 😀

[Jack Brickey]

hmmm, haven't really thought about this before but I wonder if the "before" will really work here. Trying to figure out how to state what i'm wondering...

so I wonder if "before startOfDay(-5)" will be restricted the way you want in this example...

2020-06-01 ABC-123 status changes from To Do to In progress

2020-06-07 ABC-123 status changes from In progress to Resolved

2020-06-08 ABC-123 status changes from Resolved to Closed

in the above example, will ABC-123 be included in the "-5"? Theory - yes because of the 2020-06-01 status change. In other words i think any status change would be considered not just the last one.

i may be over thinking this?

[Vineet Sawhney]

So ABC-123 should not be in the list. Really what I'm trying to do is list all the issues that are stuck in the same status for 5+ days. If not BEFORE could there be some other query to handle this? Thanks.

[Bill Sheboy]

Hi @Vineet Sawhney 

Have you tried something like:

status NOT CHANGED AFTER -5d

[Vineet Sawhney]

Hey @Bill Sheboy 

Not sure if that's a valid syntax.

[Bill Sheboy]

Oops, sorry.  Please try this:

NOT status CHANGED AFTER -5d

[Vineet Sawhney]

That worked! Thanks a lot Bill. Appreciate your help on this.

[SJ]

This is interesting since I have similar issue today with a much newer version of Jira. 

I have 7 issues that the status changed 3 days ago. 

There are no status changes older than 4 days ago that are not in the done or cancelled status.

My filter

project = Operations AND status not in (Done, Cancelled) AND NOT status changed after -7d

returns results from the issues whose status changed 3 days ago

if I tinker with the -7d and change it to -1d nothing should be displayed but the same issues whose status changed 3 days ago are listed

even if I use startofday(-7d) or endofday(-7d) the same issues that the status changed 3 days ago are still returned

This is true for the 3 projects that I've checked and I assume is system wide