Parent (Common Investment) value shows blank when Inactive

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Parent (Common Investment) value is showing blank in the field when its inactive as the lookup behind is checking only for active only.  

Steps to Reproduce: 

1. Navigate to MUX --> Project Grid 
2. In the project Grid add a column Parent and populate Parent attribute for few Projects 
   • 
3. Now navigate to MUX --> Task workspace and add attribute Common Investment Parent 
4. Deactivate the Parent Project which was associated in point 2 
5. Navigate to Task Workspace and now Parent Common Investment doesn't show the parent project even though its association is there
   • 

Expected Results: The saved values should display the investment name in the field although the investment is marked inactive. 

Actual Results: When a saved value is for an investment marked inactive, that investment is not shown in the grid list.

 

Environment

Release : 16.1.1

Cause

DE70049

Resolution

In 16.1.2 the issue of not displaying an inactive investment in the field is resolved (DE69184); the lookup was corrected by moving the clause 'is_active =1' into the @BROWSE@ construct. With this change, when using the field in the filter section, because the @BROWSE@ construct excludes inactive investments, it is not possible to filter for inactive.  This is standard behavior and this behavior won't be 'fixed' or changed.