How to identify project template used in the project creation?

book

Article ID: 20130

calendar_today

Updated On:

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:
Powered by Wolken Software