Steps to reproduce this behaviour are as follows:
- 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@
- Create an attribute:
- Object: Status Report
- Data Type: Lookup
- Populate API Attribute ID
- Provide the following parameters to the attribute under 'Lookup Parameter Mappings' section:
- inv_id = odf_parent_id
- id = [--Object ID--]
- Navigate to the Modern UX. Create a Project. Navigate to the 'Status' tab within it
- Configure the attribute from step 2 into the Canvas of the status report. Try to select a value
- Navigate to the Grid view within the 'Status' tab
- 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