Clarity

Expand all | Collapse all

CA PPM Tuesday Tip: Which template was a project created or copied from?

  • 1.  CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-16-2015 11:06 PM

    The table ODF_OBJECT_COPY_FLAT stores the source and destination project's internal IDs and keep a history of each unique combination of the source and destination projects.

     

    Here is a query to identify the internal ID of a template from which a project has been created or copied from. This does not include task copy.

     

    select templ.code copiedFrom, copied.code copiedTo, flat.created_by copiedBy, flat.created_date copiedDate

    from odf_object_copy_flat flat, inv_investments templ, inv_investments copied

    where flat.src_object_id = templ.id

    and flat.object_code = 'project'

    and flat.object_id = copied.id

     

    Example result from a project 'copied1' created from a template 'csk.majorIT', followed by a copy project done from template 'test_template', again from template 'csk.infrastructure', and again from template 'test_template':

     

    Capture.JPG



  • 2.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-16-2015 11:31 PM

    Thanks for sharing this useful info Connie

     

     

    Sry my ignorance but Related to this "followed by a copy project done from template 'test_template'" i don't know the concept to copy a project, can you give me moe details about that.

     

     

    Have a great day!



  • 3.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-18-2015 01:16 AM

    "followed by a copy project done from template 'test_template'"

     

    Suppose you create a project A using template T1

    When you run the query, the result will be -

    COPIEDFROM    COPIEDTO    COPIEDBY    COPIEDDATE

    T1                             A                XXXX            XX-XX-XXXX

     

    On the edit page of the project, you again use the copy from template feature (for the second time) and do the copy from template T2

    When you run the query, the result will be -

    COPIEDFROM    COPIEDTO    COPIEDBY    COPIEDDATE

    T1                             A                XXXX            XX-XX-XXXX

    T2                             A                XXXX            XX-XX-XXXX

     

    On the edit page of the project, you again use the copy from template feature (for the third time) and do the copy from template T3

    When you run the query, the result will be -

    COPIEDFROM    COPIEDTO    COPIEDBY    COPIEDDATE

    T1                             A                XXXX            XX-XX-XXXX

    T2                             A                XXXX            XX-XX-XXXX

    T3                             A                XXXX            XX-XX-XXXX

     

     

     

    Regards

    NJ



  • 4.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-18-2015 08:58 PM

    Got it NJ, thanks for clarity this for me



  • 5.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-19-2015 01:11 AM

    You're welcome

     

    Happy Friday !!!!

     

    Regards

    NJ



  • 6.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-17-2015 03:42 AM

    Thanks for sharing this, Connie

     

    Regards

    NJ



  • 7.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-17-2015 05:36 PM

    Thanks for the tip Connie!

    Connie Rong Fu wrote:

     

    The table ODF_OBJECT_COPY_FLAT stores the source and destination project's internal IDs and keep a history of each unique combination of the source and destination projects.

     

    Here is a query to identify the internal ID of a template from which a project has been created or copied from. This does not include task copy.

     

    select templ.code copiedFrom, copied.code copiedTo, flat.created_by copiedBy, flat.created_date copiedDate

    from odf_object_copy_flat flat, inv_investments templ, inv_investments copied

    where flat.src_object_id = templ.id

    and flat.object_code = 'project'

    and flat.object_id = copied.id

     

    Example result from a project 'copied1' created from a template 'csk.majorIT', followed by a copy project done from template 'test_template', again from template 'csk.infrastructure', and again from template 'test_template':

     

    Capture.JPG



  • 8.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-19-2015 06:02 AM

    Thanks for sharing!

    Is there also a way to check usage of templates for the Copy Task from Template funcionality within tasks?

     

    Regards,

     

    Bob



  • 9.  Re: CA PPM Tuesday Tip: Which template was a project created or copied from?

    Posted 06-29-2015 02:04 PM

    "I don't know where that milestone came from!!" read the Clarity Incident   ticket.

     

    I do. 

     

    ... and by who and when.

    ticket.jpg

     

    This ticket has been closed.

     

    Thank you Connie!