One of the lookup attributes is not showing lookup values in the Modern User Experience (MUX), but you are able to see the values in classic Clarity.
Steps to Reproduce:
SELECT @SELECT:I.ID:[email protected],@SELECT:I.NAME:[email protected],@SELECT:I.CODE:[email protected]
FROM INV_INVESTMENTS I
where I.IS_ACTIVE = 1
and UPPER(I.odf_object_code) = 'PROJECT'
and (select COUNT(1) as INV_COUNT
from INV_HIERARCHIES H
where H.PARENT_ID = I.ID) > 1
Expected Results: Attribute values are available and showing in New UX.
Actual Results: Attribute value is not available however visible in classic UI.
Note: This is not specific to MUX, rather this is caused by Auto Suggest functionality not working properly. This Auto Suggest functionality exists in Classic as well. Instead of Browsing if you start typing characters in the Classic lookup field, you can see the same behaviour as in Modern. Since MUX uses only Auto Suggest functionality, this issue appears that a lookup works in Classic but does not Modern. The problem here is with Auto Suggest vs Browse lookup behaviour that is only used in Classic.
Release : All
Component : CLARITY STUDIO
Fixed in 16.0 as Defect DE62473
Workaround: Add @[email protected] clause in the NSQL. Example below:
SELECT @SELECT:I.ID:[email protected],@SELECT:I.NAME:[email protected],@SELECT:I.CODE:[email protected]
FROM INV_INVESTMENTS I
where I.IS_ACTIVE = 1
and UPPER(I.odf_object_code) = 'PROJECT'
and (select COUNT(1) as INV_COUNT
from INV_HIERARCHIES H
where H.PARENT_ID = I.ID) > 1
and @[email protected]