How can I query which work items were kicked back from one state and into a previous state?

[Jeff Davis]

Say something is in the In Test column, and then it fails testing and is sent back to the In Progress column. Can I build a query to determine which stories in a sprint were in a certain state, and then sent back to a previous state?

[Ivan Lima · Accepted solution]

Hey @Jeff Davis, you can achieve this through the CHANGED operator. Therefore, assuming the underlying statuses of your columns "In Test" and "In Progress" are respectively the same, you can have something like:

type = story and sprint = <your sprint> and status changed from "In Test" to "In Progress"

It's worthwhile to take a look at the advanced search docs

• Advanced searching
• Advanced searching - operators reference

I hope it helps,
IL.

[Jeff Davis]

Hi, Ivan,

That's exactly what I was looking for. Thank you so much especially for providing a template query. I built what I needed based on that.

Thanks again,

Jeff