How to change the next defect ID used?

  • Questions
  • How to change the next defect ID used?
Question ID: 104049
3
0

How can I change the next defct ID used in Quality Center?

Marked as spam
Posted by (Questions: 4, Answers: 0)
Asked on February 12, 2010 7:54 pm
17 views
Answers (1)
2
Private answer

The SEQUENCES table in the project database stores the last defect used.

Each time a defect is created this value is incremented by 1 and assigend to the new defect id.

If for example you wanted to make the next defect id = 10001, the SQL syntax is:

UPDATE SEQUENCES SET SQ_SEQ_VALUE =
10000 WHERE SQ_SEQ_NAME = 'BUG'

BE CAREFUL not to set the next defect id lower than an existing defect.

Marked as spam
Posted by (Questions: 6, Answers: 167)
Answered on February 12, 2010 8:02 pm