Is there a query to find out which status reports are associated with a project?
Release : 16.1.0+
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;
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).