Dynamic lookup values are not shown in living status report canvas
search cancel

Dynamic lookup values are not shown in living status report canvas

book

Article ID: 266622

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Steps to reproduce this behaviour are as follows:

  1. Create a dynamic lookup with the following SQL
     SELECT
     @SELECT:id:id@,
     @SELECT:name:value@
     FROM
     odf_ca_cop_prj_statusrpt
     WHERE odf_parent_id = @WHERE:PARAM:USER_DEF:INTEGER:INV_ID@
     AND id = @WHERE:PARAM:USER_DEF:INTEGER:id@
     AND @FILTER@
  2. Create an attribute:
    1. Object: Status Report
    2. Data Type: Lookup
    3. Populate API Attribute ID
  3. Provide the following parameters to the attribute under 'Lookup Parameter Mappings' section:
    1. inv_id = odf_parent_id
    2. id = [--Object ID--]
  4. Navigate to the Modern UX. Create a Project. Navigate to the 'Status' tab within it
  5. Configure the attribute from step 2 into the Canvas of the status report. Try to select a value
  6. Navigate to the Grid view within the 'Status' tab
  7. Configure the attribute from step 2 into the Grid. Try to select a value

Expected Results: It is possible to select a value in steps 5 and 7

Actual Results: It is possible to select a value in step 7 only

Cause

DE70067

Resolution

DE70067 is fixed in 16.1.3.