Auditing the "sys_attachment" table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 04:55 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-07-2025 06:18 PM
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.