Thursday, December 18, 2008

Daily Scrum WIQL

If you've ever heard of SQL then you will quick understand what the Work Item Query Language (WIQL) is for Team Foundation Server (TFS). I've created a Daily Scrum WIQL that I'll use to generate a report for each Daily Scrum. Here is the WIQL:

SELECT [System.Id], [System.TeamProject], [System.Title], [System.AssignedTo], [Microsoft.VSTS.Common.Rank], [Microsoft.VSTS.Scheduling.StartDate], [Microsoft.VSTS.Scheduling.FinishDate], [Microsoft.VSTS.Common.Discipline], [System.Description], [System.ChangedDate]
FROM WorkItems
WHERE [System.ChangedDate] >= @today - 1
ORDER BY [System.ChangedDate] Desc

In Team Explorer you can save this Daily Scrum query in the "Work Items\Team Queries" folder of your Team Project. Run it, select all the result items and then copy/paste them into Excel. Then you can format the results to make a printout for everyone before the daily scrum.

No comments:

Post a Comment