Dependent lookup displaying a value by mistake in the Modern UX

Products

• Clarity PPM SaaS

Issue/Introduction

SUMMARY: Lookup on a sub object of project defaults to a value in error

STEPS TO REPRODUCE: 
1- Create an Object: Client Master
 Object ID: company_client_master
 API Attribute ID: custcompanyClientMasters
 (See Test case environment for attributes)
 
2- Create a Dynamic Query Lookup -  
   Lookup Name: Country on Client L2 subobject (Parameterized)
   Lookup ID:  company_CLIENT_L2_COUNTRY
   
3-  Query:
 SELECT  @SELECT:L.LOCATIONID:LOCATIONID@, 
   @SELECT:L.ID:ID@,
   @SELECT:L.SHORTDESC:COUNTRY@ 
 FROM ODF_MULTI_VALUED_LOOKUPS MV 
 JOIN LOCATIONS L ON L.LOCATIONID = MV.VALUE 
 WHERE @FILTER@
 AND MV.OBJECT = 'company_client_master' 
 AND MV.ATTRIBUTE = 'company_countries'
   @BROWSE-ONLY:
  AND MV.PK_ID = (SELECT C.ID FROM ODF_CA_company_CLIENT_MASTER C WHERE  C.CODE= @WHERE:PARAM:USER_DEF:STRING:CLIENT_PARAM@)
   :BROWSE-ONLY@

4- Create a Sub-Object of Project
   Object Name:  Deliverables
   Object ID:   company_deliv_prj_l2
   API Attribute ID:  custcompanyDelivPrjLs
   Master Object:   Project
   
   Attributes:
   Create typical attributes (see test case environment)
   and a field for the lookup above
   Attribute Name: Deliverable Country
   Attribute ID: company_deliv_country
   Data Type:  Lookup - STRING
 LOOKUP: Country on Client L2 subobject (Parameterized)
 API ATTRIBUTE ID:  v_deliv_country
 Lookup Parameter: 
 Client Param       company_del_client_name
 
5- Create a Blueprint for Projects with a Module - tab for Deliverables, Publish
6- Open a project that is using that blueprint
7- Go to the Deliverables tab
8- Click Plus sign for new row
9- Enter a value for Deliverable Client Name, Deliverable Kickoff Date, Deliverable Delivery Date, Stage and Deliverable Confidence
10- Wait for the Save
11- There should be no value for Deliverable Country at this point
12- update one of the non-required columns
The Country will update to the first in the ordered list, for example: Afghanistan

 

Expected Results: Lookup should remain blank if nothing is selected

Actual Results: Lookup defaults to a value if nothing is selected

Workaround: Update the Deliverable Country Field and select -None-

 

Environment

Release : 16.0.0

Component : Clarity MUX Blueprints and Administration

Resolution

Defect: DE63420

Fix included in 16.0.1