| || |
Report in Excel for Test Set\'s in QC 9.0
I would like to know the best possible way to generate a report in excel sheet for a test set which has lots of TC's and I need to have only the latest runs of those TC's in that Test Set. I would like to club fields from different Tables and how can I club the results from other Test Set's. All these Test Set's are part of a folder. For e.g. We have a folder Test_project which has multiple folders and these multiple folders have multiple Test Set's.
If we give the Test_project folder as input it should query all the sub folders and all the Test Set's within that folders and generate a report of the TC's with the latest runs as the test set's have TC's being run muliple times.
Re: Report in Excel for Test Set\'s in QC 9.0
Study relationship between below and you should be able to figure what query you need to get your desired results. For importing to excel you can use QC Excel Report feature.
td.all_lists.al_father_id (=2 if the folder is under SUBJECT in test plan)