SQL to list Tests with parent child relationship including folders

  • Questions
  • SQL to list Tests with parent child relationship including folders
Question ID: 104613
0
0

How would I write an sql to test a list of the tests in the test plan including the whole folder structure and in the order I see in the test plan module?

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on September 24, 2012 4:53 pm
29 views
Answers (1)
0
Private answer

Good Morning hollpow,

I would Highly recomend having a DBA help you with this. You will need to use the Database Reference Guide which will give you a break down of the project Databases. You can find the guide by logging into QC and click Help->Documentation Library. You will want to download the guide to you local machine to view the guide.

I will see if I cant get a sample SQL query up in little while.

EDIT: Ok you will need someone much better at SQL than My self to even write a sample Query. I can Tell you that the two tables to reference in the query are ALL_LISTS, and TEST tables. Where ALL_LISTS.AL_FATHER_ID = ALL_LISTS.AL_ITEM_ID of the Parent Folder

Marked as spam
Posted by (Questions: 1, Answers: 69)
Answered on February 15, 2013 4:10 pm