Database Values from Static Lookup
search cancel

Database Values from Static Lookup


Article ID: 205101


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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.  


Release : 15.8.1

Component : CA PPM STUDIO


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.