Information On Status Report Object Instances

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Is there a query to find out which status reports are associated with a project?

Environment

Release : 16.1.0+

Resolution

The following query can be used to find out which status reports belong to which project:

select
a.id, a.name statusreport_name,a.code, a.odf_parent_id investment,
b.name, b.code
from odf_ca_cop_prj_statusrpt a,
inv_investments b
where a.odf_parent_id = b.id
order by a.created_date desc;

 

Additional Information

Before 16.0.0, status reports were automatically created when projects were created.

The functionality was removed in version 16.0.0
to make the user experience consistent between the project creation from grid and template.

This was reported an internal user story (F23058).