The 'Idea and Project Category' Lookup has some deactivated values. When looking at the Lookup Mapping List View, the mappings with deactivated values are still there and can be modified or deleted. However if you go into the properties of a Lookup Mapping and click on the 'browse' icon for the 'Child Lookup' the deactivated lookup values are still present and there is no way to filter out the deactivated values.
Steps to Reproduce:
Expected Result: Should not see the deactivated lookup values or we should be able to filter them out of the view.
Actual Result: We see ALL defined lookup values regardless of active/inactive status, there is no way to filter out deactivated values.
The lookup definition can be modified to only show active values when browsing for new selection values and yet allow pre-saved, deactivated values to appear on the field. Follow the steps below to update the Lookup definition. This workaround is not upgrade-protected. Be sure to review the lookup definition after an upgrade for verification of resolution or reinstatement of the workaround noted here.
The full lookup definition :
SELECT DISTINCT @SELECT:LOOKUP.LOOKUP_CODE:[email protected], @SELECT:LOOKUP.NAME:[email protected], @SELECT:LOOKUP.SORT_ORDER:[email protected] FROM ODF_CA_COP_IDEA_PRJ_MAP MAP, CMN_LOOKUPS_V LOOKUP WHERE MAP.CHILD_LOOKUP = LOOKUP.LOOKUP_CODE AND LOOKUP.LOOKUP_TYPE = 'OBJ_IDEA_PROJECT_CATEGORY' AND LOOKUP.LANGUAGE_CODE = @WHERE:PARAM:[email protected] AND (@WHERE:PARAM:USER_DEF:STRING:[email protected] IS NULL OR @WHERE:PARAM:USER_DEF:STRING:[email protected] = MAP.PARENT_LOOKUP) AND @[email protected] @BROWSE-ONLY: AND LOOKUP.IS_ACTIVE=1 :[email protected]
Resolved in PMO Accelerator 3.3 delivered with Clarity 13.3
The lookup query was modified to include the @[email protected] construct.
KEYWORDS: CLARITYKB, PMO-896, pmo30open, pmo31open, clarity13resolved, clarity133resolved