Query all Template and Project linkages : Bienabee

Query all Template and Project linkages Print

Modified on: Tue, 6 Jun, 2017 at 8:16 AM

This query will help you query all template projects and their traceability to attached projects. Be sure to update the query with your respective ALM Site admin DB and connection method 'td' or 'dbo'.

SELECT tp.DOMAIN_NAME as 'Template Domain',
              tp.PROJECT_NAME as 'Template Name',
              pl.PRL_FROM_PROJECT_UID as 'Template UID',
              sp.PROJECT_NAME as 'Project Name',
              pl.PRL_TO_PROJECT_UID as 'Project UID'

FROM qcsiteadmin_db.td.PROJECT_LINKS pl

JOIN qcsiteadmin_db.td.PROJECTS tp on pl.PRL_FROM_PROJECT_UID = tp.PROJECT_UID
JOIN qcsiteadmin_db.td.PROJECTS sp on pl.PRL_TO_PROJECT_UID = sp.PROJECT_UID

Did you find it helpful? Yes No

How can we help you today?

Query all Template and Project linkages Print

Related Articles