Custom Multi Valued Lookup displaying different values on the instance property page versus List view

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Custom Multi Valued Lookup displaying different values on the instance property page versus List view.

Environment

Release:
Component: PPMSTU

Cause

STEPS TO REPRODUCE

1. Create Lookup with query as below:
SELECT
p.prid,
to_char(p.prstart, 'mm/dd/yyyy')||' - '||to_char(p.prfinish-1, 'mm/dd/yyyy') tp
FROM prtimeperiod p, prtimeperiod c
WHERE SYSDATE BETWEEN c.prstart AND c.prfinish-1
AND (p.prstart BETWEEN c.prstart-28 AND c.prstart-14
OR (to_char(SYSDATE,'D') > 3 AND SYSDATE-7 BETWEEN p.prstart AND p.prfinish-1))
ORDER BY p.prstart
2. Create custom master object
3. Create Multi Valued Lookup attribute based on the lookup created in step 1
4. Put that attribute on List and Edit Views
5. From Home menu navigate to the object list and attempt to create an instance.
6. Once instance is saved and value has been selected on Edit screen you will notice that List shows correct value but Edit screen does not. It shows first value in the list of available values.

Note: This was working as expected in version 15.2

Expected Results: Edit screen should display the correct value.

Actual Results: Edit screen does not display correct value.
 

Resolution

DE48687, NAB
query should be updated as below:

SELECT  @SELECT:p.prid:[email protected],
        @SELECT:to_char(p.prstart, 'mm/dd/yyyy')||' - '||to_char(p.prfinish-1, 'mm/dd/yyyy'):[email protected]
FROM prtimeperiod p, prtimeperiod c
WHERE SYSDATE BETWEEN c.prstart AND c.prfinish-1
AND (p.prstart BETWEEN c.prstart-28 AND c.prstart-14
OR (to_char(SYSDATE,'D') > 3 AND SYSDATE-7 BETWEEN p.prstart AND p.prfinish-1))
AND @[email protected] ORDER BY p.prstart