index > Team Foundation Server - Work Item Tracking > Problem with filter Changed by on closed work items

Problem with filter Changed by on closed work items

I have filter that shows all bug and tasks that I did during last week. However if someone close work item I do not see it in my queue. I use fileter "changed by"=@me.
Probably it is another way to get all tasks I worked on?

By the way, does any command line tool that can show work items?

SaloS

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

http://blogs.msdn.com/narend

Naren Datha - MSFT

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

SaloS

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

http://blogs.msdn.com/narend

Naren Datha - MSFT

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?

SaloS

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)

http://blogs.msdn.com/narend

Naren Datha - MSFT

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.

http://blogs.msdn.com/narend

Naren Datha - MSFT