Changing a Parameterized Lookup via XOG to non-parameterized breaks the Attribute in the MUX

book

Article ID: 203302

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Modifying a parameterized lookup via XOG to make it not parameterized breaks the attribute in the New UX, and leaves an "orphaned" parameter mapping. This modification is not allowed via the UI. 

STEPS TO REPRODUCE:

1. Go to Administration > Studio > Objects
2. Create an object called Garment and API enable it for use on the Modern UX 
3. On the attributes list, create a string type attribute called: printmethod
4. Add it to the object Properties and object List views
5. Administration > data Administration > Lookups
6. Create a Dynamic query lookup called "Garment Lkp" with the following query:
   SELECT
   @SELECT:garment.printmethod:[email protected]
   FROM ODF_CA_GARMENT garment
   WHERE @[email protected]
   AND (@WHERE:PARAM:USER_DEF:STRING:[email protected] IS NULL OR @WHERE:PARAM:USER_DEF:STRING:[email protected] = garment.name)
7. Go to Administration > Studio > Objects > Project object
8. Create a lookup type attribute (My Garment) and link it to the "Garment Lkp"
9. On the Attribute Lookup Parameter Mappings, select "Name" as Object Attibute ID
10. Add the attribute to the object Properties and object List views
11. Home > Custom Objects > Garment
12. Create two instances of the object
    Name:Garment A ID:Garment_A Printmethod: Garment A Printer 
 Name:Garment B ID:Garment_B Printmethod: Garment B Printer 
13. Create a project in Classic called Garment A
14. On the project properties view, click on the My Garment attribute binoculars
15. Garment A Printer value can be selected
16. Do the same on the project list view. The lookup value is selectable
17. Go to Modern UX (MUX)
18. Add the project attribute My Garment to a project blueprint
19. On the Grid view add the column to it
20. The Garment A value is selectable on both views.
21. XOG out the lookup
Change the lookup code from:
SELECT
@SELECT:garment.printmethod:[email protected]
FROM ODF_CA_GARMENT garment
WHERE @[email protected]
AND (@WHERE:PARAM:USER_DEF:STRING:[email protected] IS NULL OR @WHERE:PARAM:USER_DEF:STRING:[email protected] = garment.name)

to:
SELECT
@SELECT:garment.printmethod:[email protected]
FROM ODF_CA_GARMENT garment
WHERE @[email protected]

22. Flush the Clarity caches
23. On the Classic UI, using the same project, check the properties and list views
24 As the parameter mapping has been removed both values can be seen: Garment A Printer and Garment B Printer 
25. Do the same on the Modern UX: Check the Project properties and grid view

Expected Results: As the parameter mapping has been removed both values can be seen: Garment A Printer and Garment B Printer 
Actual Results: No values can be selected. None is displayed

Cause

This issue has been reported to Engineering as DE62837.

Environment

This can be reproduced in all Clarity releases

Resolution

This is currently being analyzed by Engineering