JQL: status was not changed to implemented

[Team Support Desk retail7]

Hi, 

I would like to filter issues, which were not changed to a specific status (like implemented) in a specific time range (01.06.2018-31.12.2018).

Any idea, how to do?

[Merle Fischer]

Hi @Team Support Desk retail7 

maybe try something like this:

project = XYZ AND Status was not in (implemented) AND status changed BEFORE "2018/12/31" AFTER "2018/06/01"

that query however assumes, that you are filtering for tickets that have changed status in that time... but since your time frame was half a year, I'd assuming that all tickets have changed status at least once.

Hope this helps, cheers

Merle

[Team Support Desk retail7]

exactly - if the "before" and "after" would be in relation to the status implemented, just in that case it would help. but in your example, the status change it is not, just to any status change. 

Any other idea?

[Merle Fischer]

My query return issues that were not changed to implemented in a specific time frame, but changed status, which is how I read your question.

you could alter it to this:

project = Project AND Status was not in (Implemented) BEFORE "2018/12/31" AFTER "2018/06/01"

that should return what you are after?

[Team Support Desk retail7]

I believe, my example with "implemented" leads into the wrong idea... ...I need the action changed to "open". 

So the goal is, that I will get the number of issues in a time frame, which were not set to open again. 

Is there a possibility to use "was not" changed?

[Merle Fischer]

hm I think I might not understand what you are after but that might be because I don't know your exact workflow.

I am assuming tickets are open after creation go through workflow statuses until the reach resolved and closed. So are you after tickets that were in another status and then went back to open? Or Tickets that got reopened?

Sorry maybe I already have weekend brain but I seem to not understand what you are after exactly.

[Team Support Desk retail7]

The "changed to" is just considered, if the issue was really set to that status, not during creation. 

I believe, I found a solution, but must double check. Thanks for your hints. 

[Merle Fischer]

hope my hints helped :P let me know your final query so that I can understand what you were actaully after ;)

[Team Support Desk retail7]

Mhhh... ...it's not solved so far. I need one additional impact. How could I add a condition, that the status must be set as well to requirement review, which is in our Jira a status before implemented. 

I would like to have something like "was set to opened from implemented" - but I did not found any possibility so far to do something like that. 

Any idea?

status changed to (opened) AND status changed to implemented by XXX AND status changed to closed before "2018/12/31" after "2018/01/01"