How do I know which template was a project created or copied from?

Document ID : KB000071348
Last Modified Date : 19/02/2018
Show Technical Document Details
Question:
I want to know which project templates have been used to create the existing projects. How can I knwo what is the template used?
Answer:
Here is a query to identify the internal ID of a template from which a project has been created or copied from:


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