No value to select in parameterized lookup on Propeties module

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Unable to select a dependent parameterized value on the Properties module if the parent lookup value contains a space on the lookup value ID. It works fine on the grid view

STEPS TO REPRODUCE:

1. Classic > Administration > Studio > Objects
2. Create an object with name and ID: z_op_cof and API Enable it.
3. Create following attributes:
   
   • Boolean attribute: z_active
   • String attribute: z_code
4. Classic > Administration > Data Administration > Lookups
5. Create a Static Lookup with name: my_static_lkp
   
   • Add 2 values:
     
     • Name: valuea ID: valuea
     • Name: valueb ID: value b (note the space on this ID value)
6. Back at the object created in Step 2, create a lookup attribute
   
   • Name: z_tip_cof Linked lookup: my_static_lkp
7. Classic > Administration > Data Administration > Lookups
8. Create a dynamic lookup:
   
   • Name: my_param_lkp
   • Query:
     SELECT
     @SELECT:x.id:id@,
     @SELECT:x.z_code:code@,
     @SELECT:x.name:name@,
     @SELECT:x.last_updated_date:LAST_UPDATED_DATE@
     FROM (
     SELECT odf.id, odf.z_code, odf.name, odf.last_updated_date
     FROM odf_ca_z_op_cof odf
     WHERE 1=1
     AND (
     @where:param:user_def:string:p_param2@ IS NULL
     OR odf.z_tip_cof = @where:param:user_def:string:p_param2@
     )
     @BROWSE-ONLY: AND odf.z_active = 1 :BROWSE-ONLY@
     ) x
     WHERE @FILTER@
9. Back at the object created in Step 2, create a lookup attribute
   
   • Name: my_param_lkp Linked lookup: my_param_lkp
   • Lookup Parameter mappings: Add z_tip_cof as parameter
10. Classic > Administration > Studio > Objects > Project object
11. Create a static lookup attribute
    
    • Name: my_static_lkp Linked lookup: my_static_lkp
12. Create a dynamic lookup attribute
    
    • Name: my_param_lkp Linked lookup: my_param_lkp
    • Lookup Parameter mappings: Add my_static_lkp as parameter
13. MUX > Custom Objects > z_op_cof object
14. Add Name, ID, z_active, z_code, z_tip_cof, my_param_lkp columns to the grid.
15. Create 2 rows:
    
    • Name 'aa', ID, 'aa' z_active ticked, z_code 'aa', z_tip_cof 'valuea', my_param_lkp 'aa'
    • Name 'bb', ID, 'bb' z_active ticked, z_code 'bb', z_tip_cof 'valueb', my_param_lkp 'bb'
16. MUX > Administration > Blueprints
17. Make a copy of the Project blueprint
18. Add my_static_lkp and my_param_lkp to the Properties module
19. MUX > Projects > Select any project and link it to the blueprint just created
20. Add my_static_lkp and my_param_lkp columns to the grid
21. Select 'valuea' as my_static_lkp value. You can now choose 'aa' as my_param_lkp value
22. Select 'valueb' as my_static_lkp value. You can now choose 'bb' as my_param_lkp value
23. Open the Project properties and nullify my_static_lkp and my_param_lkp values
24. Select 'valuea' as my_static_lkp value. You can now choose 'aa' as my_param_lkp value
25. Select 'valueb' as my_static_lkp value.

Expected Results: You can now choose 'bb' as my_param_lkp value

Actual Results: No values to select are displayed

Environment

Clarity 16.4.X

Cause

This is caused by DE209860

Resolution

This is currently under review

Workaround: Populate the values on the Grid view.