I suggest you ...

Creating Queries - Token for Current Iteration

When creating a work item query, you are given the option to select the iteration path for which the query is to return results for. It will be fantastic if a token was provided such as [Active Iteration] and you can specify the active iteration manually, or TFS calculating it via the Start/End dates

479 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Lambros VasiliouLambros Vasiliou shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Ramon DurãesRamon Durães shared a merged idea: Add variable @CurrentSprint (WorkItem>Shared Queries>Sprint Backlog )  ·   · 
    stevesteve shared a merged idea: Add @CurrentIteration variable to TFS  ·   · 
    Bryan HintonBryan Hinton shared a merged idea: Add an @CurrentIteration filter to create dynamic work item queries  ·   · 
    AnonymousAnonymous shared a merged idea: TFS Current Sprint Macro for query builder: if i have an Iteration tree like ProjectName -> Sprint Number -> Sprint 80 -> Reports. I would  ·   · 

    15 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Alex ScottAlex Scott commented  ·   ·  Flag as inappropriate

        If you change your iteration path from Sprint 1 to Current, all items in Sprint 1 will automatically move to Current. When you rename Current back to Sprint 1, all items are moved back into Sprint 1 and you are now ready to rename Sprint 2 to Current. Works great when you manage sprints in the iteration path. All your current sprint queries never have to change from /Current. We moved away from managing our sprints in the iteration path and now we realize we traded one set of problems for another.

      • wesleywesley commented  ·   ·  Flag as inappropriate

        On January 11, 2012 11:49 p.m Visual Studio team (Product Team, Microsoft) wrote: "We have heard this feedback more often, and is something we would really love to do."

        415 days ago.

        Lambros Vasiliou shared this idea · Oct 4, 2011

        514 days ago.

        How can the Visual Studio Team release a feature with such a flawed design?

        I think we need a uservoice "idea" to improve uservoice satisfaction. If we create it today we might get satisfaction in 600 days.

      • MaloshMalosh commented  ·   ·  Flag as inappropriate

        Adding a new Field such as "Query Name" (or "Query") can alternatively resolve the need for defining new tokens.
        For example: I would manually edit a Query named 'Active Iteration' periodically, while having in multiple Queries a Clause with Field set to "Query", Operator set to "Satisfied" and Value set (from a drop-down list) to "Team Queries\Current Sprint\Active Iteration".
        I think such feature would increase the Query flexibility significantly, and maybe simpler for implementation (than user-defined tokens)?

      • DanDan commented  ·   ·  Flag as inappropriate

        I like current token, would save me from editing the query every week.

      • AlexAlex commented  ·   ·  Flag as inappropriate

        Having iteration start and end dates available for query and as a column option would be massively beneficial.

      • Terry ShortTerry Short commented  ·   ·  Flag as inappropriate

        I also would prefer an explicit Current Interration/Sprint that the Scrum team/master sets and all the current sprint queries can then use that.

      • Phil SpokasPhil Spokas commented  ·   ·  Flag as inappropriate

        I recommend *not* having TFS calculate this automatically, but rather the Scrum team/Scrum Master make an explicit declaration about which sprint is *current* and exactly when. There's too much variability in real life over when the current sprint is actually current at sprint transition and planning time.

      • techSagetechSage commented  ·   ·  Flag as inappropriate

        It seems that it shouldn't be terribly hard to do since the Team Project Dashboard shows the Current Iteration. Use that code wherever the system variables like @Project are created. Of course, I'm probably drastically oversimplifying this since I know nothing about how VS is developed.

      • AnonymousAnonymous commented  ·   ·  Flag as inappropriate

        A useful important thing also would be a query variable like @CurrentIteration for workitem queries. In my opinion for Scrum a minimal requirement.

      • wheelswiemannwheelswiemann commented  ·   ·  Flag as inappropriate

        This feature would be very beneficial, especially when you look at the opportunities for leveraging the dashboard type views on a project portal.

      • Andy BrayAndy Bray commented  ·   ·  Flag as inappropriate

        Agree - this would save having to update all of the 'current sprint' queries every couple of weeks which is a bit clunky.

      • Visual Studio teamAdminVisual Studio team (Product Team, Microsoft) commented  ·   ·  Flag as inappropriate

        Thanks for your suggestion.

        We have heard this feedback more often, and is something we would really love to do. We had to make the tough decision to put it below the cut line when we compare it to the other work we need to get done for Dev11.

        But it is definitely something we consider for the future.

        Ewald Hofman (TFS Program Manager)

      Feedback and Knowledge Base