CA PPM: 'User Value 1' which use a custom dynamic lookup is correctly displayed in classic UI. In the new UX some values are not displayed.

Document ID : KB000100412
Last Modified Date : 10/08/2018
Show Technical Document Details
Issue:
STEPS TO REPRODUCE

1. Create Custom Object ODF_CA_MY_OVERTIME.
Add attributes key_code and active

2. Create some instances on Custom Object :
Example - key_code: ABC, CAL, NGT, OVT, ABC.
They are Active.

3. Create custom Dynamic Lookup ID: MY_OT_VALUES_LKP

NSQL :

SELECT
@SELECT:TE.PRID:PRTIMEENTRYID@,
@SELECT:substr(ot.key_code,1,30):USERVALUE@,
@SELECT:substr(ot.key_code,1,30):DISPLAYVALUE@
FROM
PRTIMESHEET TS,
PRTIMEENTRY TE,
(SELECT key_code
FROM ODF_CA_MY_OVERTIME
where active=1
) ot
WHERE TS.PRID = @WHERE:PARAM:USER_DEF:INTEGER:USERDEFTSID_PARAM@
AND TS.PRID = TE.PRTIMESHEETID
AND @FILTER@

3. In Admin side, go to Timesheet Options.
- Associated the lookup created in step 3 to 'User value 1' Lookup
- Add the User value 1 in the layout.

4. In classic UI, enter timesheets for a resource for 4 Tasks.
For each Task Select a value for 'User value 1'. For one task select value ABC, for another one select value CAL, for another one select value NGT , for another one select value OVT

5. In Admin side, go to System Options. Check 'Activate Timesheets'. Save.

6. In new UX, find that timesheet for the resource and Observe the 'User value 1' values

Expected Results:
'User value 1' with values ABC, CAL, NGT, OVT should be displayed.

Actual Results:
'User value 1' with value ABC is displayed.
'User value 1' with values CAL, NGT, OVT are not displayed.
Cause:
Caused by DE41781
Resolution:
Fixed in 15.5
Additional Information:
The problem is that we are doing a wildcard search to get the values for the lookup and there are multiple values that match ‘OVT’, ‘CAL’ and ‘NGT’ when doing the wildcard search. For example, I changed ‘OVT’ to ‘OVTx’ and it works because the wildcard search only returns the single value and the lookup can be resolved.