Clarity

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':

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!

"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

Got it NJ, thanks for clarity this for me

You're welcome

Happy Friday !!!!

Regards

NJ

Thanks for sharing this, Connie

Regards

NJ

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':

 

Thanks for sharing!

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

Regards,

Bob

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

I do. 

... and by who and when.

This ticket has been closed.

Thank you Connie!