Classic UI - Parameterized Lookup Attributes - Assignment List view does not display values of child attributes

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Steps to reproduce this issue are as follows:

1. Create a Master Object
2. Create a Sub Object of the above Master Object
3. Create an instance of the Master object from Step 1
4. Create an instance of the 
5. Create a sub object of the Investment objectSub Object from Step 2

6. Navigate into a Project instance and create an instance of the object from Step 5

7. Create a Dynamic Lookup using the following query. In the "FROM" clause provide the DB table of the object from Step 1
 select
 @select:id:[email protected],
 @select:name:[email protected],
 @select:last_updated_date:[email protected]
 from odf_ca_object_from_step_1
 WHERE @[email protected]
8. Create an attribute in the object from Step 5 with the following details:
 a. Data Type = Lookup
 b. Lookup = The lookup from Step 7
9. In the instance from Step 6, display attribute from Step 8, choose instance from Step 3

10. Create a Dynamic Lookup using the following query. In the "FROM" clause provide tables associated with objects from steps 5 and 1
 select
 @select:inv_sub.id:[email protected],
 @select:inv_sub.name:[email protected],
 @select:inv_sub.odf_parent_id:[email protected],
 @select:master_obj.id:[email protected],
 @select:master_obj.name:[email protected]
 from odf_ca_object_from_step_5 inv_sub
 left join odf_ca_object_from_step_1 master_obj on master_obj.id=inv_sub.c_mst_tst_data
 where @[email protected]
 and (@WHERE:PARAM:USER_DEF:INTEGER:[email protected] = inv_sub.odf_parent_id or @WHERE:PARAM:USER_DEF:INTEGER:[email protected] is null)

11. Create another Dyanmic Lookup using the following query. In the "FROM" clause provide tables associated with objects from steps 2 and 5
 select
 @select:q.id:[email protected],
 @select:q.name:[email protected],
 @select:q.odf_parent_id:[email protected]
 from (
  select id,
  name,
  odf_parent_id
  from odf_ca_object_from_step_2
  where odf_parent_id = 
  (
   select c_mst_tst_data 
   from odf_ca_object_from_step_5
   where [email protected]:param:user_def:integer:[email protected]
  )
 ) q
 WHERE @[email protected]

12. Create an attribute in the Assignment object with the following details:
 a. Data Type = Lookup
 b. Lookup = The lookup from Step 10
 c. Lookup Parameter Mappings section:
  - parent_project = v_project_id
13. Create another attribute in the Assignment object with the following details:
 a. Data Type = Lookup
 b. Lookup = The lookup from Step 11
 c. Lookup Parameter Mappings section:
  - parent_object_id = Attribute From Step 12
  
14. Navigate into the same project instance as in Step 6
15. Create a Task. Assign a resource into that Task
16. In the Assignment List view, display the attributes from Steps 12 and 13
17. Populate instance from Step 6 against the attribute from Step 12
18. Populate instance from Step 4 against the attribute from Step 13

Expected Results: Values of both the attributes from Steps 12 and 13 are displayed in the Assignment List View

Actual Results: Value of attribute from Step 13 is missing in the List View. It is however visible in the Properties view.

Environment

Version: 16.0.2

Cause

Due to a defect with ID DE65838.

Resolution

This issue is being reviewed by Engineering.