Status Changed From Works with "Before" but not "After"

[Rebecca Vaught]

Hello - I'm trying to create SLAs for incidents. I'm using the same query but changing the Before/After Statement.

BEFORE returns results but the AFTER one doesn't. Does anyone know why the AFTER wouldn't return results?

Does work

project = X AND issuetype = Incident AND cf[11430] = Incident AND "Reported By" = "Site Support Team" AND cf[11406] = Production AND "Incident/Defect Severity" = "Sev 4 - Low" AND status changed from "New Ticket" to Open before 2d

Doesn't Work

project = X AND issuetype = Incident AND cf[11430] = Incident AND "Reported By" = "Site Support Team" AND cf[11406] = Production AND "Incident/Defect Severity" = "Sev 4 - Low" AND status changed from "New Ticket" to Open after 2d

[Rilwan Ahmed · Accepted solution]

Hi @Rebecca Vaught ,

The "CHANGED" operator is used to find issues that have a value that had changed for the specified field.

This operator has the following optional predicates:

• AFTER "date"
• BEFORE "date"
• BY "username"
• DURING ("date1","date2")
• ON "date"
• FROM "oldvalue"
• TO "newvalue"

Some examples for right use is:

1. project = IT AND status changed from "Waiting for support" to "Waiting for Requestor" AFTER startOfWeek()
2. project = IT AND status changed from "Waiting for support" to "Waiting for Requestor" AFTER "2023-07-31"
3. project = IT AND status changed from "Waiting for support" to "Waiting for Requestor" BEFORE "2023-07-31"

[Rebecca Vaught]

Thanks for the reply, Rilwan! Do you know why BEFORE is returning results though? Based on your answer, it looks like I'm not supposed to be able to query on "BEFORE 2d."

[Rilwan Ahmed]

Hi @Rebecca Vaught ,

I am not 100% sure, but what I think is "After" is considered as Today. So today +2 days is not possible as it is future date.