How can i tell when a Defect is linked to a test case in the test set , and a tester sets the status to "Blocked" I want to be able to tell What test cases in the test Lab I should not run. is there a way to go through all the test cases in all test sets and see if there stats is blocked and if so tell if there is a linked Defect to it and how many?
I think you will have to make a SQL query from TESTCYCLE to the LINK table. Where Entity type = Testcycle (I think). Then link from the LINK table to the BUG table, you'll find that defects there with their status.