Query to Download Test Case from Test Plan from TD
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: Query to Download Test Case from Test Plan from TD
The test plan folder names are in td.all_lists. From memory you can join on al_item_id = ts_subject.