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

[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

[David Morton]

Not sure I completely follow what you are after, but the attribute values will be in ODF_CA_PROJECT.hen_dem_status column (where 1 = "In progress" etc - from your lookup NSQL)

 

Last Updated Date is a bit tricky - you need to be AUDITing that custom attribute, and then values will be in CMN_AUDITS table. If you are not AUDITing that attribute (or you clear the audit history after a number of days) then you will not have the details in the database.

[matej256]

Hi Dave, 

 

Aaah, didn't noticed that....

Smart as usual  

Thanks

 

Matej