How to identify project template used in the project creation?

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

Issue:

Is there a way to identify a template used in the creation of projects?

Environment:

Applies to all supported PAS environments. 

Resolution:

1. Create a Project Template (make a note of the internal ID from the URL)
2. Once created, create new project from template created in step #1 (make a note of the internal ID from the URL)
3. Check the following database table: ODF_OBJECT_COPY_FLAT
   
   SELECT * FROM ODF_OBJECT_COPY_FLAT
4. Main Columns from this result provide the following information:
   
   OBJECT_ID = Corresponds at internal ID of the new project created
   SRC_OBJECT_ID = Corresponds at internal ID of the Template used

Note: The unique exception that occurs is when project created through project template is marked as new template and then this new project template is used, for this case in the previous table 2 records will be added. This is by product design.

Environment

Release: ESPCLA99000-13.2-Clarity-Extended Support Plus
Component: