We also have thousands of tests and have found whenever I have to link our 2000+ tests to a release or to a configuration, I do it on the back-end via SQL as the system(QA Complete application) chokes and cannot really handle the volume.
This may not sound like an appealing workaround but I have found it works.
What that does require though is some knowlege of SQL and using a loop with a variable in SQL (I had to do some searches to help).
So for example with linking 2000+ tests to a release:
USE SoftwarePlanner; (use the database called "SoftwarePlanner")
DECLARE @cnt INT = 4; -- from Test ID (make a variable and set it to the first test ID I want affected)
WHILE @cnt < 2338 -- To one under this Test ID (while loop - end the loop at the ID I specify - here 2337)
BEGIN
INSERT INTO dbo.TraceabilityLinks(ProjId, EntityCode1, FKId1, EntityCode2, FKId2,
DateUpdated, UpdateUserId) (This inserts a row in the "TraceabilityLinks" table )
VALUES ('11876','Releases','8','Tests',@cnt , '2016-11-07 15:20:25.250','24904');
(so here Values - 11876 in our case is Project ID for the project in QA Complete)(The Release ID 8 is the release I am concerned with)
SET @cnt = @cnt + 1;
END;
So basically you may need to get familiar with some of the tables in the QA Complete database.
I found that once I did this I could use excel to create any kind of report I needed and also I could go through the back-end when making changes to large amounts of test data.
What it does require is a little knowledge of the tables and a little knowledge of SQL. Also always TEST the query with a small sampling before executing on a large set of data.
For Configurations - There is a database table called TestConfigurations
For Linking there is a table called "TraceabilityLinks"
You will also need some tool to connect with the QA Complete database and running queries (so you will need write access to the database) - for me - Microsoft SQL Server 2014 (but this may depend on how your application and database are setup... we have an on-premises version.)
Good luck!
- Erik
Related Content
- 9 years ago
- 2 years ago
- 2 years ago
- 5 years ago