Problem with filter Changed by on closed work items

Problem with filter Changed by on closed work items

• edwaldo

  Unfortunately on surface it doesn't seems like such query can be written using V1 wiql format.
  
  

• Chris Fraelic

  Can you give your complete filter Probably someone else edited your item before you did, in which case you can use "'changed by' ever @me" fliter.

  Yes, we do have command line tool for workitems in our powertoy. http://blogs.msdn.com/bharry/archive/2006/09/07/744993.aspx

  
  
  

• Fekih Mehdi

  Here is something to think about: Supposing we have a table called workitem with this data, how would a sql query would look like to achieve what you need

  you can read about WIQL syntax from samples/documents in VSSDK. Download VS SDK from http://msdn.microsoft.com/vstudio/extend and check out the documents & samples under "VisualStudioTeamSystemIntegration\Work Item Tracking"

  Here is link to influence features or make suggestions: https://connect.microsoft.com/VisualStudio/feedback/CreateFeedbackForm.aspx FeedbackFormConfigurationID=774&FeedbackType=1 (Choose Visual Studio 2005 Team Foundation Server in the Version combo box)

  
  
  

• Erik Bertrand

  Thanks a lot for answer.
  However I have one more question.
  How to combine changed date and user who made changes. For example, I'm developer and I need to get tasks and bugs that I worked on last week. But bugs after they are resolved should be tested. So they assigned to testers. And they can change it.
  So I need filter that shows only bugs that only I changed last week but not testers. If I use changed date TFS filters bug on last changed date (not only me) but not last changed by me.
  
  

• DBRICHARD

  It's a pitty. However could answer on the following questions.
  1) Where I can read about wiql format
  2) Is V2 version of this format developping Can I influence on some features of it Where I can do it
  
  And one small question. I downloaded powertoy you mentions in first answer. It's very very good tool. Probably you know more useful tools for TFS
  

• @nt

  Missed to mention about other tools available for TFS or workitemtracking:

  - Tools for codeplex: http://www.codeplex.com/Tagging/TagDetail.aspx TagName=TFS

  - SP1 Beta: http://blogs.msdn.com/bharry/archive/2006/09/26/772371.aspx

  - Solutions from partners: http://msdn.microsoft.com/vstudio/teamsystem/downloads/partners/

  - TFS widgets from Accentient, Inc.: http://accentient.com/widgets.aspx

  - Tools from blogs (example: attachment paste tool): http://blogs.msdn.com/jmanning/ , http://blogs.msdn.com/buckh/

  This is obviously not exhaustive list, but few that I am aware of.

  
  
  
• Problem with filter Changed by on closed work items