AnsweredAssumed Answered

Last Updated Date of values in a Multi Valued Lookup

Question asked by clarityhelp123 on Jun 11, 2013
Latest reply on Jun 13, 2013 by sundar
Can anybody help me with a query to get last updated date of values in the multi valued lookup..For ex: if a multi value lookup has 3 values and all 3 values are updated on 3 different days I need to write a query to get the values and the dates when they were modified...In the ODF_MULTI_VALUED_LOOKUPS last_updated_date field is updated whenever a lookup is updated not the value... I also audited the multi value lookup. In the CMN_AUDITS table it is storing different dates for each of the values but the value_after and value_before does not have the correct id. (value of multivalue lookup).

Outcomes