johnc_1's avatar
johnc_1
New Contributor
10 years ago
Status:
Accepted for Discussion

Speed up linking of tests to configurations

There are only 2 ways to link a test to a configuration...either

1. select the test (or test set), open the link to items, select the configuration folder, and check each sub item (e.g. Windows8>IE, and Chrome and Firefox), repeating for each config folder.

2. select the configuration, open the link to items, specify type and folder, and individually check every item (test) in the folder.  Repeat for every configuration.

 

Even with just a few Windows environments, each with 3 or 4 different browsers, times our 2500 tests, and this is a monumental task.  While we could have done it as we created tests, our focus was on creating the tests, and not linking..that was a mistake.  

However now, we need to make these links, yet we are looking at nearly 10,000 clicks/steps.

 

If nothing else, in the selection of tests (or sets) drop down, add a "Select All" to check all tests in that folder.  Then we would just need to repeat for each Configuration, each folder...a much more manageable task.

QAC-SelectAll.bmp

 

 

  • ehendin's avatar
    ehendin
    New Contributor

    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.

  • PepeFocus's avatar
    PepeFocus
    Regular Visitor

    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.