How do I remove linked tests from a requirement in the database?
| ♥ 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 |
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. Marked as spam
 Posted by jameslcoleman (Questions: 2, Answers: 300) Answered on August 19, 2015 6:57 pm
|