ad_audit_trail

ad_audit_trail [ -bind bind ] id_list audit_table_name main_table_name \
    id_column_list [ columns_not_reported ] [ start_date ] \
    [ end_date ] [ restore_url ]

Defined in tcl/ad-audit-trail.tcl

Returns an HTML fragment showing changes to one row in the OLTP system between the times start_date and end_date (YYYY-MM-DD HH24:MI:SS). There will be one section for each row in the audit table and a single section for the occurrence of id (must be unique) in main_table, the entire affair sorted by time (descending). If a restore_url is provided, a link will appear next to each non-delete section to the restore url with the current rowid and ad_audit_trail arguments. ARGUMENT audit_table_name - table that holds the audit records main_table_name - table that holds the main record id_column_list - list of column names representing the unique key in audit_table_name and main_table_name id_list - list of ids of the unique record you are auditing columns_not_reported - tcl list of names in audit_table_name and main_table that you don't want displayed start_date - ANSI standard time to begin viewing records end_date - ANSI standard time to stop viewing records restore_url - URL of a tcl page that would restore a given record to the main table. Form variables for the page: id id_column main_table_name audit_table_name and rowi

Switches:

-bind (optional)

Parameters:

id_list
audit_table_name
main_table_name
id_column_list
columns_not_reported (optional)
start_date (optional)
end_date (optional)
restore_url (optional)