Create an Excel report containing the folder structure (names) in Test Plan

  • Questions
  • Create an Excel report containing the folder structure (names) in Test Plan
Question ID: 107622
0
0

I would like to create an excel report to pull the folder structure along with folder names from the Test Plan module. I have checked the ALL_LISTS table, but it is showing only the father id and absolute path. How do I convert the absolute path into an actual folder path? Can someone help me with the query?

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on April 28, 2017 6:44 pm
9 views
Answers (1)
0
Private answer

The query below will pull the first ten levels of folders from the Test Plan module. If you have more than ten levels in your Test Plan, you will need to add the appropriate additional number of levels into the query.

SELECT
AL1.al_description, AL2.al_description, AL3.al_description, AL4.al_description, AL5.al_description, AL6.al_description, AL7.al_description, AL8.al_description, AL9.al_description, AL10.al_description
FROM ALL_LISTS AL1
FULL OUTER JOIN ALL_LISTS al2 on al2.al_father_id = al1.al_item_id
FULL OUTER JOIN ALL_LISTS al3 on al3.al_father_id = al2.al_item_id
FULL OUTER JOIN ALL_LISTS al4 on al4.al_father_id = al3.al_item_id
FULL OUTER JOIN ALL_LISTS al5 on al5.al_father_id = al4.al_item_id
FULL OUTER JOIN ALL_LISTS al6 on al6.al_father_id = al5.al_item_id
FULL OUTER JOIN ALL_LISTS al7 on al7.al_father_id = al6.al_item_id
FULL OUTER JOIN ALL_LISTS al8 on al8.al_father_id = al7.al_item_id
FULL OUTER JOIN ALL_LISTS al9 on al9.al_father_id = al8.al_item_id
FULL OUTER JOIN ALL_LISTS al10 on al10.al_father_id = al9.al_item_id
WHERE al1.AL_DESCRIPTION = 'Subject'
ORDER BY al1.AL_VIEW_ORDER ASC

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on April 28, 2017 6:44 pm