Where are the comments ( work notes & additional comments ) stored in ?

[GassanHirra]

Where are the comments ( work notes & additional comments ) stored in ?

after some research i found this table sys_journal_field, but this table acts more like a history of the comments so you can't make a record in it and have it pop up on the request's additional comments or work notes 
is their a table where a record in it is a direct reference to the comments (meaning if you edit/insert the record in the table it will be edited/inserted on the request's comments).

Thanks for your help.

[Ankur Bawiskar]

Hi,

sys_journal_field stores the individual journal entry made for that field

Example: incident + work notes might have multiple entries in this table based on when work notes was updated

No other table which stores the journal entry info

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Sanket Khabiya · Accepted solution]

Hello,

 1) Journal entries are captured in sys_journal_field

2) History activity are captured in various tables like:

        sys_history_set

        sys_history_line

refer link to: Delete or Update Activity log and Journal Field Entries

Regards,

Sanket

[KKrabbenhoft]

What if you want to make the[additional comments] and [work notes] use rich text? How does this impact the journal table?