Clarity

  • 1.  Project count template wise

    Posted May 14, 2015 02:31 AM

    I want to know how many projects are created from template1, how many from template2 (New from Template). Which table should I refer to find project and related template information together?

    Uruj



  • 2.  Re: Project count template wise

    Posted May 14, 2015 02:38 AM

    Check this -

     

    Record of the template a project was created from

    https://communities.ca.com/message/114916958#114916958

     

    NJ



  • 3.  Re: Project count template wise

    Posted May 14, 2015 02:41 AM

    Also, check this -

    Number of projects created using templates

    https://communities.ca.com/message/100987639#100987639

     

    NJ



  • 4.  Re: Project count template wise
    Best Answer

    Posted May 14, 2015 02:42 AM

    So, finally, this is what you should look at -

     

     

    Clarity: How to identify template used in the created project?

    Document ID:  TEC600149
    Last Modified Date:  10/7/2013
    ShowHide Technical Document Details  

    • Products
      • CA PPM
      • CA Governance, Risk & Compliance Manager
    • Releases  
      • CA PPM:Release:12.1
      • CA PPM:Release:13.0
      • CA PPM:Release:13.2
      • CA PPM:Release:13.3
    • Components  
      • CLARITY PPM APPLICATION ADMIN, STUDIO, XOG & PROCESSES

     

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

    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 (the source)

     

     

    NJ



  • 5.  Re: Project count template wise

    Posted May 14, 2015 02:52 AM

    Thanks NJ, will try and confirm.



  • 6.  Re: Project count template wise

    Posted May 14, 2015 03:01 AM

    You're welcome

     

    Will await response

     

    NJ