Journals and the Activity formatter
Journal
fields technically don't store data in the table that the Journal
field is on, but instead, create entries in the Journal Entries [sys_journal_field]
table. These journal entries, along with other values corresponding to changes to audited fields from the Sys Audits [sys_audit]
, History [sys_history_line]
, and Record History[sys_history_set]
tables, are displayed in the Activity formatter.
Note
Journal
fields only work on audited tables. Adding such a field will modify a non-audited table's System Dictionary entry so that it becomes audited.
There are three types of Journal
fields that you can add to your forms: journal_list
, journal
, and journal_input
.
Journal_list
fields don't actually store data, but are used more like formatters. If you visit the dictionary record for a journal_list field (such as when you're creating it), you can navigate to the Advanced view using the Advanced view
UI action on the dictionary form. On the Advanced view, you'll...