AnsweredAssumed Answered

Where to find (DB table) attribute values from Dynamic niku SQL lookup

Question asked by matej256 on Dec 6, 2017
Latest reply on Dec 8, 2017 by matej256

Hi All, 

 

I'd like to retrieve values by SQL query for project for one custom attribute behind which is Dynamic SQL lookup. Currently I was not able to find anything in "common" tables like CMN_LOOKUPS, CMN_LOOKUPS_V. Only definition from CMN_LOOKUP_TYPES...Does someone know how to retrieve attribute values for particular project? 

Custom attribute:

 

Lookup query behind :

 

Attribute on project page:

 

We would like to retrieve all 3 underlined attributes (id, status (only visible to users) and last_updated_date) from database for particular project. 

 

Thanks a lot!

Matej

Outcomes