JQL Help

[Magdalena Migas]

Dear Community,

I would like to find all issues in Jira which have changed status from "New" to "To Do" in the last 4 weeks. Unfortunately, the filter gives me all issues which have changes status from new to "to do" then "In Progress" and "done".

Here's my code

project = "XYZ" AND status changed from NEW to "TO DO" AFTER -4w AND component = "XYZ"

Please advise how to limit issues just to receive one status changed from new - to do only?

[Jack Brickey · Accepted solution]

Hi @Magdalena Migas , I'm not sure I understand your goal. Your JQL looks correct from what I was thinking your goal was so obviously I don't understand. You mention getting issues returned that are currently in states other than "To Do" so maybe you want to only show issues in "To Do"?

project = "XYZ" AND status = "TO DO" AND status changed from NEW to "TO DO" AFTER -4w AND component = "XYZ"

if not, please help be better understand.

[Magdalena Migas]

Hi Jack ! 

Thats exactly what I was looking for ! 

Thank you :)

[Sudarshan]

Can you try seeing this result using the control chart?
you would get the time each issue spent in the column, and indirectly obtain the number of issues.!

Though, I understand your question is to create a JQL. :) 

[Magdalena Migas]

I just want to limit results issues just for one transition of status changed from new to "to do:

[Sudarshan]

yes, I get your need.!
lets wait for any other answers here.! :) 
I just gave you a Workaround, not exactly what you needed