Auditing the "sys_attachment" table

bonsai
Mega Sage

I would like to keep a history of attachment updates and record when someone replaces a file.

 

I was thinking about creating a business rule for the "sys_attachment" table, and I found a good one.

It seems that by checking the audit field of a record of type "Collection" in the "sys_attachment" table of a [Dictionary Entry] record, it will be recorded in the audit table.

 

Will there be any problems if I record attachment information in the "sys_audit" table?

1 REPLY 1

HIROSHI SATOH
Mega Sage

Since "sys_attachment" does not record the actual file, I don't think there will be any "sys_attachment"-specific issues such as performance issues.