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.

Deactivated Lookup displays invalid Expression


Article ID: 7932


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Steps to Reproduce: 

1. Navigate to > Administration 

2. Click on > Lookups 

3. Search for ‘Investment Type’ (ID= INV_TYPE / Static Dependent List)

4. Click on ‘Values’ tab 

5. Expand Project Investment 

6. Expand ‘Six Sigma’ 

7. Deactivate ‘Define’ 

8. Navigate to ‘Project’ 

9. Click on [Build Power Filter] 

10. Object= Select ‘Stage’ 35

11. Right = click on binocular icon > Tick ‘Six Sigma’ and Click on Add 

12. Select Evaluate 

Expected Result: Successful Evaluated Expression 

Actual Result: Invalid expression 


This issue is documented as defect DE35255 


14.X, 15.1 and 15.2


This is resolved in 15.3



Additional Information


When the power filter is created, manually update the expression to remove the inactive value and expression validation will be saved successfully. 

Another alternative is to pick all the child values that are shown in the browse window instead of picking the Parent Level.