MSP / OWB - restrict inactive values from lookup
Article ID: 220394
Updated On:
Products
Issue/Introduction
Is there a way to restrict inactive values from a lookup in projects in Microsoft Project (MSP) and Open Workbench (OWB) in the designated field you set it to? For example, you set a field called Delivery Method to Text27 in MSP. In Text 27 the lookup shows all values whether they are active or not in Clarity.
Environment
Release : All Supported
Cause
This is working as expected. As part of a fix for CLRT-7314 where inactive and active lookups displayed, an asterisk was added for inactive lookups.
Resolution
It is not possible to restrict inactive lookup values from showing in the MSP or OWB drop down lists. The asterisk (*) is used to distinguish between the inactive and active lookups. (Example of inactive lookup value: (*) Value3)
The one additional option would be to update the lookup value name in Clarity to say Inactive in the name. Example of how it would appear in MSP with this change:
See MSP: Field Mappings Between MSP and Classic PPM for more details where the above and other information on lookup behavior with MSP is referenced.
Additional Information
Feedback
