Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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.