How do I remove linked tests from a requirement in the database?

  • Questions
  • How do I remove linked tests from a requirement in the database?
Question ID: 106349
0
0

Hi,

An inexperienced user linked aprox 80 thousand test cases to 1 requirement. I am looking for advice on a way to uncouple without using GUI. I would like to remove them via a database query, but am not comfortable that I know all tables to touch. I don’t want to delete the test, just the association with the requirement. I can do this in the REQ_COVER database but am not sure if anywhere else. Couldn’t find anything logical in the Test databases but would think there would be entry somewhere that ties back to the req.

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on August 19, 2015 6:54 pm
3 views
Answers (1)
0
Private answer

Hi,

Try running the query listed below in the REQ_COVER table within the Projects database on your SQL Server Management Studio. After you run the query, go back into ALM, refresh, and see if all of the unwanted tests have been removed from the Requirement. Hope this helps.
DELETE FROM td.REQ_COVER
WHERE RC_ITEM_ID <> '';

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on August 19, 2015 6:57 pm