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
We have hundreds of queries that are of the form:
And WorkItemType In Task,Bug
And State in New,Active
And IterationPath Under @Project\Current
It would be really good to be able to write this basic query "All active bugs and tasks in current iteration" and then just "include" it in derived queries (e.g. base + "and AssignedTo=JoeBloggs")
Having just discovered a bug in one such query, and spent hours "copying and pasting" the core query into all the variations, this would have been a massive time-saver.
We often look at the backlog when doing quality checks and audits for work created or amended within an iteration.
When using the query editor, the only options on a date or datetime field when using the operator In is today -x days
Could we have for all date fields an option to select In then an iteration path and have the query return all matches where the date of the field being searched is within the start and end dates of the iteration
Why will you insert the possibility to Get the current Iteration Path in query filter: like TFS @CurrentIteration
When Sprint N finished and started Sprint N+1 we have to update all queries manually. It will be nice to have "Active Iteration Query" type or some kind of alternative.
Simplifying the user experience
Add @CurrentIteration variable to TFS so your team queries know which teh current sprint is like @Project or @Me
Since we can detect what the current iteration is for a team - it would be nice to be able to build work item queries that continually changed as the iteration changed - an @CurrentIteration filter would be fantastic!
TFS Current Sprint Macro for query builder:
If i have an Iteration tree like
ProjectName -> Sprint Number -> Sprint 80 -> Reports
I would a macro that allows all queries to change sprint automatically.
ProjectName -> Sprint Number -> "CurrentSprint" -> Reports
We are happy to let you know that we have addressed this suggestion. It will be enabled on Visual Studio Online this week, and if you have an on-prem installation, it will be included in TFS 2015 RTM.
For more details see the feature description at https://www.visualstudio.com/en-us/news/2015-mar-10-vso.
When used, i see error: "TF20037: No Iterations are selected for the team. The macro '@CurrentIteration' is undefined."
Gaz Iqbal commented
Is this included in the "Update 5 - CTP 3" or will it only be available in the final version?
Christian Beermann commented
Thank you for listening to the community, Brain Harry! Now I don't have to edit all queries after the iterations for my 6 scrum teams. I love this little variable and it saves a lot of time each month! Big like for your dev-team. ;-)
Luc van Vugt commented
Ben M commented
nice one thanks chaps
Marco Medrano commented
Thank you, that is the moment when you feel yourself listened :)
Sina Jazayeri commented
Julio Raffaine commented
Really cool guys, this will be very useful! Thanks!
Priya Babu commented
That's awesome!! Thank you.
S Olson commented
Max Cascone commented
Looking forward to this! I also second anon's request for @current_area_path for use when working with sub-teams.
Phil Spokas commented
Whoo hoo!!! (I'm generally pretty reserved, so you can take this as awesome news.) T/his has been an annoying soft spot in the product and will save me from the manual Sprint/Iteration "dance" that I never got around to automating)
Luc van Vugt commented
Carlos Silva commented
When creating a ssrs report for TFS, how can i query SQL to display past, current and future iterations ?
in search of help as i am knew to TFS.
Yep, @Current Sprint would be great!
It seems this will never be impleted. I'd suggest another implementation instead:
Add two new fields to selectable field list: IterationStart, IterationEnd. With these two new fields we can use @Today macro to filter Work items belonging to current/past/future iterations.
Greg Prosch commented
Yes, please! And even better would be the ability to reference next and prior say:
Current + 1
Current - 1
Yes, please provide @Current Sprint !
Kevin Auch commented
It is a nice workaround but I would prefer a specific tag for the current iteration.
We use a hierarchical iteration system like this:
You can then query a specific iteration, and anything in the "groups: current, next past and future.
At the end of the iteration, you just drag Iteration3 into "Past" and it magically moves everything in that iteration to the "past" group (without adding any history to all the hundreds of individual items)