Clarity: PMO Lookup Mapping List View and Properties pages show Inactive Lookup Values

Document ID : KB000049326
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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:

  1. Login to Clarity as an administrator user

  2. Administration > Lookups > Idea and Project Category Lookup

  3. Deactivate an existing value, such as 'Other'

  4. Home > Setup: Lookup Mappings

  5. Click into the existing Lookup Mapping for 'Idea and Project Type/Category', 'Major Project', 'Other' (or any other mapping)

  6. Click 'browse' icon for 'Child Lookup'

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.

Solution:

WORKAROUND:

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.

  1. Login to Clarity as an administrator user

  2. Administration > Lookups > Search for Lookup ID = OBJ_IDEA_PROJECT_CATEGORY_PARAM

  3. Navigate to the Lookup > Query Tab

  4. Within the Query text box, at the end of the existing query, add the following browse-only condition statement
    @BROWSE-ONLY:
    AND LOOKUP.IS_ACTIVE=1
    :BROWSE-ONLY@

  5. Click 'Save and Continue' button

The full lookup definition :


SELECT  DISTINCT
@SELECT:LOOKUP.LOOKUP_CODE:LOOKUP_CODE@,
@SELECT:LOOKUP.NAME:LOOKUP_NAME@,
@SELECT:LOOKUP.SORT_ORDER:LOOKUP_SORT@
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:LANGUAGE@
AND    (@WHERE:PARAM:USER_DEF:STRING:TYPE_CONSTRAIN@ IS NULL OR
@WHERE:PARAM:USER_DEF:STRING:TYPE_CONSTRAIN@ = MAP.PARENT_LOOKUP)
AND     @FILTER@
@BROWSE-ONLY:
AND LOOKUP.IS_ACTIVE=1
:BROWSE-ONLY@

STATUS/RESOLUTION:
Resolved in PMO Accelerator 3.3 delivered with Clarity 13.3
The lookup query was modified to include the @BROWSE-ONLY@ construct.

KEYWORDS: CLARITYKB, PMO-896, pmo30open, pmo31open, clarity13resolved, clarity133resolved