I want to know which project templates have been used to create the existing projects. How can I knwo what is the template used?
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