I want sum up how many issues that status was changed from "On Hold" to "At risk" between 2016-05-02 and 2016-05-06. I use syntax "Changed" and "During", but it filtered additional issues that status changed from "On Hold" to "At Risk" prior to 2016-

Question

I want sum up how many issues that status was changed from "On Hold" to "At risk" between 2016-05-02 and 2016-05-06. I use syntax "Changed" and "During", but it filtered additional issues that status changed from "On Hold" to "At Risk" prior to 2016-05-02.

My syntax is project = ABC AND issuetype = "shopping" AND status changed from "On Hold" to "At Risk" AND updated >= 2016-05-02 AND updated <= 2016-05-06 ORDER BY updated DESC

Frank Yu_hwhnul · Answer

Hi Doug,

Right now, I am tracking the historical record of "Open->Ready for Triage". As a result of your formula. there are two scenarios are inconsistent with the requirements:

* This record was On Sat May 7, and should not in result list of 2016-05-02 ~ 2016-05-06.

- 5 days ago

StatusOpen [ 1 ]Ready for Triage [ 10104 ]

2. There were two records occurred on Fri May 6, but Open->Ready for Triage was first on Fri, then user changed its status Ready for Triage->Investigate. 
1 week ago

StatusOpen [ 1 ]Ready for Triage [ 10104 ]

1 week ago

Investigation Details Katie Ho to ensure this is required for initial go-live at Coastal sites.StatusReady for Triage [ 10104 ]Investigate [ 10803 ]

Doug Swartz · Answer

Frank, here is an attempt to rephrase your request. Let us know if this is what you want: List any issue which moved from On Hold to At Risk between 2016-05-02 and 2016-05-06 which is still At Risk at the end of the day on 2016-05-06 If that is what you want, then this query should work: Issue Changed from "On Hold" to "At Risk" during(2016-05-02, 2016-05-06) and status was "At Risk" on 2016-05-07

Frank Yu_hwhnul · Answer

Good idea to use "not" syntax. Well, if I have more than 7 status (Open, On Hold, On Track, At Risk, Behind Schedule, Escalated, Closed), and all issue statuses can be transitioned each other, I have to write 6 times of "not" in case of any exception status.

Could you pls translate the following idea into JQL syntax? Thanks.

If {

issue type = "At Rsik" by 2016-05-06)

If

{

Issue Changed from "On Hold" to "At Risk" during(2016-05-02, 2016-05-06)

}