| || |
TD Query to download from Test Plan
I want to download test cases from Test Plan of TD to an Excel.I have written a Macro for this in which I am firing SQL queries. I can extract data from Test Lab by specifying the Test Lab Folder however I can not extract the data from Test Plan from a specific folder. Can anyone please tell the query to extract the data. I am very near to the solution yet so far....I can not see any column in any TD database table which holds the Test Plan folder names. I have scanned the entire OTA documentation.
Re: TD Query to download from Test Plan
The test plan folder names are in td.all_lists
Join al_item_id to ts_subject.