Information On Status Report Object Instances
search cancel

Information On Status Report Object Instances

book

Article ID: 260416

calendar_today

Updated On:

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;