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;