VSTS/TFS How to Change a Work Item ID
hello,
i able change workitemid values match organization's work order tracking system's id. read interesting post alludes can done. (http://social.msdn.microsoft.com/forums/en/tfsgeneral/thread/89239212-06b7-41a3-aafe-168d8c0593b8). comes caveat emptor there's risk of violating referential integrity.
so, following questions , thoughts come mind:
- how can change in work item id value accomplished?
- if can done, apparently database field not identity column , application handles assignment of numbers.
- could microsoft team designed database put in cascading updates & deletes enforce referential integrity? if not, why not?
i'm missing maybe thread fill in blanks.
thanks,
shapij
hi shapij,
based on description, seems want organize work items id requirement.
i noticed mentioned is my reply in post. mentioned, not recommended manually change default work item id since id field relates several data tables in database. if change one, need change other tables. risky important work.
however, think might try trick work. can customize 1 new id field and manually assign value it. field controlled ourselves. tfs not automatically change it.
firstly, need download , install team foundation server power tools. need feature "process editor" inside work.
for more information on tool, please check: http://msdn.microsoft.com/en-us/teamsystem/bb980963.aspx.
after launch team explorer, please go tools menu >> process editor >> work item types >> open wit server. work item type editor.
in field tab, click "new" create new field. can enter information of new id field.
(note: "refname", can enter name want.)
you can refer following screen shot:
then go layout tab, add field onto work item dialog box.
please check following screen shot:
then refresh team explorer.
when create a new work item, "item id" field in the dialog box like:
when save work item, "item id" data saved database on server.
hope helps! if have concern, please feel free let me know.
best regards,
yichun chen
msdn subscriber support in forum
if have feedback on our support, please contact msdnmg@microsoft.com
please remember mark replies answers if , unmark them if provide no help.
welcome all-in-one code framework! if have feedback, please tell us.
based on description, seems want organize work items id requirement.
i noticed mentioned is my reply in post. mentioned, not recommended manually change default work item id since id field relates several data tables in database. if change one, need change other tables. risky important work.
however, think might try trick work. can customize 1 new id field and manually assign value it. field controlled ourselves. tfs not automatically change it.
firstly, need download , install team foundation server power tools. need feature "process editor" inside work.
for more information on tool, please check: http://msdn.microsoft.com/en-us/teamsystem/bb980963.aspx.
after launch team explorer, please go tools menu >> process editor >> work item types >> open wit server. work item type editor.
in field tab, click "new" create new field. can enter information of new id field.
(note: "refname", can enter name want.)
you can refer following screen shot:
then go layout tab, add field onto work item dialog box.
please check following screen shot:
then refresh team explorer.
when create a new work item, "item id" field in the dialog box like:
when save work item, "item id" data saved database on server.
hope helps! if have concern, please feel free let me know.
best regards,
yichun chen
msdn subscriber support in forum
if have feedback on our support, please contact msdnmg@microsoft.com
please remember mark replies answers if , unmark them if provide no help.
welcome all-in-one code framework! if have feedback, please tell us.
Archived Forums V > Team Foundation Server - General
Comments
Post a Comment