ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Custom Multi Valued Lookup displaying different values on the instance property page versus List view
Article ID: 131538
Updated On:
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.
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.
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.
Environment
Release:
Component: PPMSTU
Component: PPMSTU
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
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
Feedback
Yes
No
Powered by
