It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,831
×36
×2

question asked: Jul 13 '16, 2:59 p.m.
question was seen: 2,303 times
last updated: Jul 14 '16, 11:46 a.m.

Related questions

Is it possible to change an RTC work item ID in the back-end database using a SQL Server query?

0
Matthew Clark (107●1●13●47) | asked Jul 13 '16, 2:59 p.m.
If it is possible, what CCM table is this data stored in?  Can someone provide a sample query?  Thanks!

Accepted answer

1
permanent link
Kevin Ramer (4.5k●9●185●201) | answered Jul 13 '16, 4:50 p.m.
It might be possible, but there are no good reasons to attempt.   The ID is updated on each new work item and I would expect that there are constraints that prevent "reusing" the ID so you couldn't change work item #100 to work item #10.  Conversely, if the highest current id is 1000, changing some id to 1024 might break something in the future.
Ralph Schoon selected this answer as the correct answer
Comments
Ralph Schoon commented Jul 14 '16, 3:22 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

This is definitely nothing you should do for many many reasons. You are not supposed to do any operation directly on the databases, unless support suggests to do so. The chance of breaking your database is high and it is also not even possible to access the data directly in many cases.

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Matthew Clark (107●1●13●47) | answered Jul 14 '16, 11:46 a.m.
Thanks guys. The plan was to delete an old work item, and replace a newer work item with the old ID. We needed to do this because a multi-select field on the old work item was set to medium size and running out of string bytes. I did a quick search of the CCM database and was unable to find the data I was looking for.

We are going with a different solution that does not involve changing back-end data. Thanks again!

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.