Delete workitem CMMI Project

Hi,

Please let me know any wok items in CCI project or some make them not appear in queries.

[103 byte] By [Sanjoyan] at [2007-12-20]
# 1

Work items can not be deleted, in any kind of project.

For making them not appear in queries you can always change its state and ask about valid states in the query

LuisFraile at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Work Item Tracking...
# 2

You can find information on deleting work item at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=327599&SiteID=1.

Let me know if you still need help.

-Mohammad

MohammadIqubal-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Work Item Tracking...
# 3

I need to know, if I delete workitem from the tables WorkItemsAre, WorkItemsWere, and WorkItemsLongTexts in that order in a transaction will that ensure that the given workitem is entirely deleted ? (assuming no attatchments or links for the given workitems)

Also I identify work items by title.... (assuming they are unique) so what shall be the "where" clause for the delete statement .....

Please provide sample code ..........

Thanks in advance

Sanjoyan at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Work Item Tracking...

Visual Studio Team System

Site Classified