Lookup value disappears after being saved

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A lookup is showing instances of an object as long as they have not been used as part of a lookup attribute in an object.

However, after setting the value for the lookup attribute, the value disappears from both the available results (expected) and the attribute value (not expected). When checking the database, the value is correctly saved for the lookup attribute.

Cause

The lookup code does not contain (or is not correct) a BROWSE-ONLY construct.

Resolution

The BROWSE-ONLY will make the condition apply only when selecting (browsing) new values, but not when displaying current existing values.

An example of using the BROWSE-ONLY construct:

SELECT ...
FROM ...
WHERE @FILTER@
@BROWSE-ONLY:
AND IS_ACTIVE = 1
:BROWSE-ONLY@

Additional Information

Configure Lookups > BROWSE-ONLY Construct for Dynamic Query Lookups