I have been trying to get some data for a pivot table for management - in a non-hosted install.
We need to find all tests run between dates, by project, case title, who ran the case, and the result (passed, failed, blocked) of the test.
One of the issues is that the person who created the run (we exclusively use Test Runs) is not the same as who was assigned to the test. In couple of our groups - QA is more of a test manager. QA sets up the test run and then the person who runs the actual individual test assigns the test case to themselves.
So only way I can see who was assigned the test (essentially who ran the individual test) is going off of the Test table. The test table has a LOT of records per run_id. One of the test runs has 85 individual tests, assigned between 2 people but the test table 137 records for the run_id and of course the case_id for each record in the table is different.
Additionally the only place to check dates for what was run is from the Test_Activity table which compounds the issue.
Is there any way to get the info we need?