Lookup values are duplicated in lookup dropdown when both of them have similar hidden keys

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Lookup values showing twice and duplicated in lookup dropdown when both of them have similar hidden keys

STEPS TO REPRODUCE:

1. Login to Classic UI.
2. Navigate to Administration -> Lookups.
3. Create a New Lookup Named "Test Lookup Duplicate". Select the type as dynamic lookup.
4. In the query section, use the below query.

SELECT @SELECT:q.CODE:CODE@,    
@SELECT:q.NAME:NAME@
FROM(
SELECT 'test' as code, 'Test' as name from dual
union
SELECT 'test_1' as code, 'Test01' as name from dual
union
SELECT 'test_2' as code, 'Test02' as name from dual
union
SELECT 'test_3' as code, 'Test03' as name from dual
) q
WHERE @FILTER@

5. Set the Hidden Key as "Code" and Display attribute as "Name".
6. Navigate to Administration -> Objects -> Select Project Object -> Attributes.
7. Create a new attribute "Test Lookup Dup" as Lookup Type and select the lookup created in Step 3.
8. Add an API Alias for the attribute created in Step 7.
9. Navigate to Modern UX -> Project Grid. Click on Columns and add the Attribute to the Grid.
10. Double click on the column and select value as 'Test' for any project instance.
11. Click on the Attribute column for the project instance again.

 

Expected Results: We will observe that "Test" value is selected and "Test01","Test02","Test03" are displayed after that.

Actual Results: We will observe that "Test" value is selected and "Test01","Test02","Test03" are duplicated showing twice each.

Environment

Clarity Release 16.2.x

Cause

DE131338

Resolution

DE131338 is fixed in 16.3.0 (Targeted to release November 2024) and also backported to 16.2.3 patch 1 

Broadcom SAAS customers will have this fix included with 16.2.3 PROD upgrade