Description:
The List view does not display selected, saved values on the second, parameterized look-up attribute if the parameterized look-up definition contains an embedded UNION statement. These values appear for selection in the List View Edit Mode browse and appear in the investment properties page.
Parameterized Look-up Example using Object Instances & incorporating a UNION Statement in the look-up.
This example uses Object Instances. The customer wants to be able to add an attribute to an Investment Object - this example will use the 'Application' Object for selecting an 'Activity'. Once the 'Activity' value is selected, a second attribute (that is the parameterized look-up) will be filtered based on the selected 'Activity' value to show only the appropriate 'Phase' for that activity.
Typically, the parameterized look-up example will have a one parent -to- many children relationship. For example, you could have a list of Phases and for each specific Phase, you have many Activities. So, typically the first attribute will allow the user to select the 'Phase' and then the second attribute, a parameterized look-up; will show a filtered list of 'Activity' values related to the value selected on the first attribute.
This example reverses the fields, because the desired behavior is that the end-user should select an 'Activity' first and then the second attribute, for the parameterized look-up will return the appropriate 'Phase' value.
The parameterized look-up definition for the 'Phase' shall have an embedded UNION statement so that there is built-in logic to cover the following scenarios:
- Activity value is selected and the Phase value on the Activity record matches existing Phases
- Activity value is NOT selected; offer the end-user the option to select 'None' for the Phase
- Activity value is selected, but the Phase value on the Activity record is not filled in but we want to offer the end-user the option to select 'Unknown Phase' value.
Steps to Reproduce:
See attachment for details on how to reproduce this case study.
Expected Result: The List View should show saved values for the parametrized look-up as it does on the properties page.
Actual Result: The List View does NOT show some saved values for the parameterized look-up as it does on the properties page.
Solution:
Workaround:
View and edit the lookup values through the investment properties page.
Status/Resolution:
This issue has been documented as CLRT-60305 and is assigned to development for review. If you are experiencing this problem and the workaround above does not significantly help, please contact CA Clarity Support.
Keywords: CLARITYKB, CLRT-60305, clarity12open.