TFS Team Query: get all changed work items from a specific time

Question

Apparently, when defining a new command request, it is impossible to provide the “Modified date” field with a time stamp (format “2009-12-14 10:00:00”). I get the error message: "The request failed. It is not possible to indicate the time when the request is executed using date precision."

Is there a workaround for this? I just need a list of work items that have changed since the last "x" minutes.

Answer 1

The solution is to write your own WIQL query: http://teamfoundation.blogspot.com/2008/01/specifying-date-and-time-in-wiql.html .

Answer 2

I ran into the same issue trying to request the latest updates and working around it by doing the following

// defined elsewhere private DateTime lastUpdated; string consult = "select * from WorkItem where [Created Date] > ' " + lastUpdated.ToString("MM/dd/yy") + "' AND [Work Item Type] = 'Test Case'"; IEnumerable<ITestCase> tcc = testManagementTeamProject.TestCases.Query(consult).Where(tp => tp.DateCreated > lastUpdated); 

I did something very similar to get the test results.

Answer 3

The last parameter of this query designer allows you to determine the accuracy:

dayPrecision

When TRUE, indicates that DateTime should be allowed for the whole day. Often it is TRUE, so as not to be more accurate for a certain time.

Answer 4

To filter your objects in TFS for a specific date, stick to this format: