How to save project list values for a field from ALM project
Question ID: 107328

I need to pull from an ALM project a very large drop down project list of value choices for a field, Its quite a few values so having to do it manually would be quite annoying. Anyway to easily do this from database or some export in the UI?

Marked as spam
Posted by (Questions: 56, Answers: 1)
Asked on January 9, 2017 3:42 pm
Answers (1)
Private answer


First, we need to identify from the DB the project list via its name, what its LS_PATH reference is. The path is how ALM in the DB links what uses the list and its values.

Site admin can be used to do this or directly in the DB. I like using site admin as the hierarchy of projects is easier to see and navigation is quicker for those who might not be overly familiar with the actual database layout that is seen in a tool such as SQL Management Studio.

Example from site admin is below. For this example, I am going to pull the value for a project list named ''Browser''.

I ran this query then in site admin, under the project where my lists is located. My project was demo, and I expanded the tree view and then clicked on the LISTS table. Then I placed the query as seen below.

![alt text][1]

From this result, we need the LS_PATH value, which is AAAABO in my example.

Using that value, I jump over to my SQL Server Management Studio (for me located on same server as my database).

Here I chose a New Query and use the following query to pull my results then.


This then will show me all the values from the project list ''Browser'' from my project Demo.

Results can be saved as a CSV or similar file for use in Excel or other application.

![alt text][2]

[1]: /storage/temp/537-siteadminsql.png
[2]: /storage/temp/538-sqlserverresultquery.png

See my comment to this answer for a solution on how to try and distinguish subitems from a list.

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on January 9, 2017 3:47 pm
For subitems, try the below query which gives you a second column showing Parent (folder). Select l.LS_NAME, (Select m.LS_NAME From m Where l.LS_FATHER_ID = m.LS_ID) as 'Parent' From l Where LS_PATH LIKE '%AAAABO%' ![alt text][1] ![alt text][2] [1]: /storage/temp/541-projectlistwithsubitems.png [2]: /storage/temp/542-subitemqueryresult.png
( at January 9, 2017 4:02 pm)
Great solution, exactly what I needed. And appreciate the subitem extra. Quite beneficial.
( at January 9, 2017 4:33 pm)

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top