How to identify project template used in the project creation?

Document ID : KB000020130
Last Modified Date : 14/02/2018
Show Technical Document Details

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.