I'm trying to do a portlet based on the audit table cmn_audits.
It looks like the table stores the date (last_updated_date) and the editor of the object (last_updated by) based on the PREVIOUS edit,but does not capture when the currently audited change was made, and who by... am I getting that wrong?
Has anyone else seen this?
I need to know who made the latest change and when they made it... is that possible to query out of the audit tables?
Any help or suggestions will be appreciated!