SQL Query - Retrieving Spaces

Description
Martin Schröder
Posts: 1
Joined: Wed Oct 14, 2015 9:21 am

SQL Query - Retrieving Spaces

Postby Martin Schröder » Wed Oct 14, 2015 9:29 am

Hello everybody,

does anybody know how to retrieve a list of spaces (ModuleFolders) in one project via SQL query?

I was able to retrieve all modules in one project:

"SELECT DISTINCT M1.C_PK FROM MODULE M1, PROJECT P1 WHERE M1.FK_URI_PROJECT = P1.C_URI AND P1.C_ID = '$projectId'"

But I cannot filter it to only one module per space.

Thanks in advance.

Martin

Return to “Polarion Application Lifecycle Management (ALM)”

Who is online

Users browsing this forum: No registered users and 4 guests