Issue:
Is there a way to identify a template used in the creation of projects?
Environment:
Applies to all supported PAS environments.
Resolution:
- Create a Project Template (make a note of the internal ID from the URL)
- Once created, create new project from template created in step #1 (make a note of the internal ID from the URL)
- Check the following database table: ODF_OBJECT_COPY_FLAT
SELECT * FROM ODF_OBJECT_COPY_FLAT - 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.