AnsweredAssumed Answered

Number of projects created using templates

Question asked by jpereza on May 9, 2013
Latest reply on Apr 11, 2014 by another_martink
Hi,

Currently we have three templates

1 - Template Name: TI Projects / Code: ti_projects
2 - Template Name: External Projects / Code: external_projects
3 - Template Name: Other Projects / Code: other_projects

I know that there are the following tables:

INV_INVESTMENTS
INV_PROJECTS
SRM_PROJECTS
SRM_PROJECTS_PROJ_V
ODF_CA_PROJECT

I noticed that in INV_PROJECTS there a column named 'IS_TEMPLATE' (1 corresponds Template, 0 not ...), however I'm not able how I can get the relationship to known count of projects that were created using specific template.

I want to build a custom report with the following information:

Template Name | Number of Projects |

TI Projects | 300 |
External Projects | 188 |
Other Projects | 200 |

Where I can to find this relationship?

Thanks you,
Juan

Outcomes