Addressing a parent level of @CurrentIteration in the query [azure-devops-server]

Question

I've been searching it for a longer while and still have no answer. I would like to automate creation of a set of queries for the dashboard relevant to the particular quarter. Currently, queries are copied-pasted every quarter with updated iteration path under eg xx\2022 Q4, and the structure is as follows

2022 Q3

• Sprint 1
• Sprint 2
• Sprint 3
• Sprint 4

2022 Q4

• Sprint 1
• Sprint 2
• Sprint 3
• Sprint 4

I wanted to use @CurrentIteration, yet the problem is that then the query pulls out the results only of the current sprint instead of the whole quarter.

Is there any way to address the parent of @CurrentIteration in the query (so 2022 Q4 in this case instead of only Sprint 1) that would be automatically updated every quarter?

Answer 1

I know this is a bit of an old question, but I wanted to post a workaround in case it may help others.

I create a separate team with no members that is something like "Quarterly View" and then under "Iterations" for that team, I just add the parents or whatever level I would like this kind of filtering. Then when you build your query, you can make it "Iteration Path Under @CurrentIteration [Project Name]\Quarterly View".

This should give you a best of both worlds because you can still work with more fine-grained sprints while making queries/view that are built on any scale you would like.

Answer 2

According to your description, I did some research and test, the @CurrentIteration and there is currently no option to set it to parent level (2022 Q4) to include the entire quarter.

Maybe you could try to create a sliding window of your team's iterations query to check if it meet you requirements.

If not, you could use "Request a feature" on the left side of Developer Community to open a new suggestion ticket.