AnsweredAssumed Answered

How can I query Audit logs via MySQL?

Question asked by lobby lobby on Mar 20, 2014
Latest reply on Mar 22, 2014 by Francesca Shiekh
Hi, (Sugar CE) I've enabled auditing on some of the fields within my custom modules.

However, I'm having difficulty in picking out the various updates/logs via mySQL.

I can't seem to figure out the correct JOIN statement so that I can get a full log.

Does anyone have a mySQL select statement that will allow me to get the most recent field change from the audit records in relation to a particular field in the custom module?

Apologies if I'm not being specific enough

Paddy

Outcomes