new fields on audit table

Hello,

If I have understood your question, you want to audit extra fields. Admin > Studio > Module name > Fields > Select the field > Mark "Audit" as true > Save

Hope this helps.

(P.S. accounts_audit table doesn't need extra fields to hold the altered values. If you find the solution with what I have said earlier, please drop those extra fields from accounts_audit table)

Hi,

Thanks for the answer, but that is not what I looking for, because I need these columns on the table. I already know that if I check a field as Audit, it will appears on the audit table everytime that a change was made.

My intention, actually, is to preserve these columns, and fill with a value from the table accounts_cstm everytime that a change is made on an account, like the example.

I need to know what part of the code fill the audit table fields.

Hi,

Thanks for the answer, but that is not what I looking for, because I need these columns on the table. I already know that if I check a field as Audit, it will appears on the audit table everytime that a change was made.

My intention, actually, is to preserve these columns, and fill with a value from the table accounts_cstm everytime that a change is made on an account, like the example.

I need to know what part of the code fill the audit table fields.

Hello,

You can find the query for audit entry in include/database/DBManager.php called from data/SugarBean.php (save_audit_records)