I am trying to put together a query that indicates cards that have 'rolled over' from one sprint to another. This should happen from time to time, but too much roll over is a flag that something is wrong. Unfortunately Azure DevOps (Azure Boards) doesn't have an 'out of the box' way of finding this data.

I need this data to be transparent so I can take it back to the team and try to find solutions.

I have tried to find this, but short of using APIs to create a data warehouse and then querying the data, somehow.... Figured there has to be a better way?

  • Hi jharris8567, it's unclear what have you done to try to achieve it and what blocks you from doing it. The question is in need of more details / clarity. Jan 26 '20 at 10:12
  • @Tiago - I tried to express that I have tried A LOT. Hence why I said besides using APIs to create a data warehouse. I haven't found ANYTHING out of the box. Ideally there would.be a way to set up a query (In Azure Boards) to pull this data. I have tried a lot of different ways to structure such a query, I am just not that knowledgeable on them, thus me reaching out for help. Jan 28 '20 at 15:20
  • «I have tried A LOT» doesn't say anything. Same goes for «I haven't found ANYTHING out of the box» [Suggestion: How did you search (which search engine, what terms were used, ...)?]. Also, is an "out of the box" solution required in this question or you're 100% sure there isn't any? Jan 28 '20 at 15:34
  • But it does say something. I can't post the literal 50 different queries I tired. And no an out of the box isn't required. I BELIEVE the 'issue' that I am having is finding a way, inside Azure Boards Queries, is finding historical data. I am not sure it is possible. Jan 28 '20 at 15:49
  • It can also be just a word to let us do the work for you without effort. Jan 28 '20 at 15:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.