Issue with OOTB lookup PARENT_INVESTMENT

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

We are using OOTB field "Parent" on project object, which has been associated to an out of the box lookup "Parent Investment"(ID:PARENT_INVESTMENT) to it. This lookup brings up all active projects and ideas.

The problem is that the project or idea selected as a value on this parent field is disappearing on the application, when that particular project or idea becomes inactive.

We identified this is happening because of the condition which makes lookup to brings only the active ones placed not inside the ":Browse-only" statement.

Please help us on this issue.

Environment

Release : 16.0.1

Component : Clarity Studio

Resolution

PARENT_INVESTMENT lookup is a System type and should not be modified as it is used in the application for our of the box functionality so our suggestion would be to create your own custom lookup with appropriate NSQL logic as per your requirement where it will not exclude inactive investments.