Database Values from Static Lookup

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A static lookup is associated to an attribute on the Investment object, and there are projects in the system with selected values for this attribute. However, when querying the ODF_CA_INV table looking for investments associated to a specific lookup value ID, only three investment records show up when there should be more, as there are more than three projects in the UI with this lookup value selected.  

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

This can occur if there are multiple lookup values with the same name, but with different lookup value ID's. The field on the project properties will only show the name of the lookup value, and not the ID. Querying for records associated to the second lookup value ID will return the other projects.