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?
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!
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.
Aaah, didn't noticed that....
Smart as usual