View Change Log / Audit Tables

[elvinjoe]

Hi guys!!!

I have installed SugarCRM 5.0 Enterprise Edition. . the system is really good!!!

I have a simple problem though. . . can anyone help me in how to clear the data in an audit table/View Change Log ?

Thanks a bunch!!!!

-elvin

[kuske]

The audit data is stored in tables named <object>_audit, eg. accounts_audit for accounts.
You can only delete them in mySQL Query Browser with normal SQL statements.
For accounts eg. you enter just

delete from accounts_cstm;

If you want to delete alle entries older than a special date (e.g. 1st Sep. 2007) you can enter

delete from accounts_audit where date_created < '2007-09-01';

There is no webinterface in SugarCRM to clear audit logs (yet).

[elvinjoe]

That explains a lot. . . thanks bro!!!