Speed up linking of tests to configurations

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 

I've expressed the same thoughts on linking requirements to a release or linking tests to requirements. It's a very cumbersome, tedious process.  It would be great if they allowed the linkage information to be included in .CSV files that are used to upload tests and requirements.

Looks like this issue has sat around for over a year and has gone nowhere :catsad:

I agree this needs to be improved.  There are several things like this in QAC that require hundreds or thousands of clicks/steps to complete which as OP pointed out a lot of overhead and incredibly inefficient.  A select all as one poster mentioned would be an improvement but there are other modern UI workflows that could make this better.

A "check all" button is much needed here.

Any technical reason you guys didn't implemented yet?

Hi John!

We are adding the Traceability option to Configurations (from the drop down menu) which will make it a little bit easier. However, with thousands of Tests I can see the need for something much more efficient.