Tim Van Wassenhove home

Sometimes i want to know which WorkItems i have closed (or completed) between two dates. According to Amit Ghosh it’s not possible to write such a query so i wrote some code that uses the TFS SDK to get that list

static void Main(string[] args)
{
	TeamFoundationServer tfs = TeamFoundationServerFactory.GetServer("tfsrtm08");
	WorkItemStore wis = (WorkItemStore)tfs.GetService(typeof(WorkItemStore));

	DateTime begin = new DateTime(2008, 1, 1);
	DateTime end = new DateTime(2008, 2, 28);
	string username = "Darren";

	foreach (WorkItem workItem in FindChangesByUserInRange(wis, username, begin, end))
	{
		Console.WriteLine("[{0:00000}] {1}", workItem.Id, workItem.Title);
	}

	Console.WriteLine("Press any key to continue...");
	Console.ReadKey();
}

static List<workItem> FindChangesByUserInRange(WorkItemStore workItemStore, string username, DateTime begin, DateTime end)
{
	string query = "SELECT System.ID, System.Title FROM workitems WHERE [Changed By] EVER '{0}' AND [State] IN ('Closed', 'Resolved') AND [Changed Date] >= '{1}'";
	query = string.Format(query, username, begin.Date.ToShortDateString());

	List<workItem> result = new List<workItem>();

	foreach (WorkItem workItem in workItemStore.Query(query))
	{
		if (IsChangedByUserInRange(workItem, username, begin, end))
		{
			result.Add(workItem);
		}
	}

	return result;
}

private static bool IsChangedByUserInRange(WorkItem workItem, string username, DateTime begin, DateTime end)
{
	foreach (Revision rev in workItem.Revisions)
	{
		string changedBy = (string)rev.Fields["Changed By"].Value;
		if (changedBy == username)
		{
			DateTime changedDate = (DateTime)rev.Fields["Changed Date"].Value;
			if (begin <= changedDate && changedDate <= end) 
			{ 
				return true; 
			} 
		} 
	} 
	return false; 
}