Why is a project missing from cop_program_v

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Majority of the projects and programs in the system are showing up in the cop_program_v but a few are missing. 

Environment

16.4.1

Resolution

Below is a snippet of the code used to generate the cop_program_v view. 

SELECT a.prid AS program_id,
    a.prid AS project_id,
    0 AS is_program
   FROM inv_projects a
  WHERE a.is_program = 0 AND NOT (EXISTS ( SELECT 'x'::text
           FROM prsubproject
          WHERE a.prid = prsubproject.prrefprojectid));

As per the above code, if a project is a subproject of any investment in the system, then it will not show up in the cop_program_v view.