search cancel

How to access display mappings Description value defined in project attribute?

book

Article ID: 257753

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

In Calculation, I want to use specific value defined on Display Mappings section of Object Attribute.. I have searched many tables like [niku].[ODF_MAPPINGS] and [niku].[ODF_DISPLAY_MAPPINGS] but can not find the values associated with it.

Example -

 

Environment

Release : 16.0.1

Resolution

The Display mapping Description can be found in cmn_captions_nls table. IDs below will vary from each environment and the lookup that description is needed for.

Below 2 queries I ran but those internal IDs will be different for you of course.

select * from CMN_LOOKUPS where id in (5027409,
5027408,
5027407)

select * from cmn_captions_nls where language_code = 'en' and pk_id in (5027409,
5027408,
5027407)