Hi Roni, It looks like it's possible - just not through Visual Studio.
You'll get an error like: --------------------------- Microsoft Visual Studio --------------------------- You cannot supply a time with the date when running a query using date precision. The error is caused by «[System.ChangedDate] > '2008-05-20T12:30:28.0000000'». --------------------------- OK --------------------------- Solution: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1527744&SiteID=1 Query qry = new Query(myworkitemstore, myquery, mycontext, false); ICancelableAsyncResult car = qry.BeginQuery(); WorkItemCollection items = qry.EndQuery(car); Where the false tells it to allow times. The parameter is called dayPrecision. By default, it is true thus disallowing times for date/time columns in the WIQL. Regards, Grant Holliday | Team System MVP<https://mvp.support.microsoft.com/profile/Grant.Holliday> Email: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> | Blog: http://ozgrant.com<http://ozgrant.com/> | Mobile: +61 (0)402 414 446 ________________________________ From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of RAHMAN,Roni [EMAIL PROTECTED] Sent: Tuesday, 20 May 2008 12:24 PM To: [email protected] Subject: [OzTFS] Report or team query that filters on time Hi All, Has anyone created a report or query that can filter on time. E.g. Return all work items that were created in the last 5 minutes? If so can someone please point me in the right direction. Regards, Roni OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. View the web archives at http://www.mail-archive.com/[email protected]/ Powered by mailenable.com, supported by www.readify.net
