Which table are RITM comments stored in?

[chrismarriott]

When I look at a requested item, there's a "Notes" tab which allows me to see activity on the item, comments that people working on the item have added, etc. I need to make some changes to the visibility of these comments, but I can't find which table they're stored in. Can anyone enlighten me as to where they're stored, please?

Thanks,

Chris

[Chuck Tomasi · Accepted solution]

Additional comments and work notes are stored in a table called sys_journal_field.

You can access them in script via the getJournalEntry() method.

https://developer.servicenow.com/app.do#!/api_doc?v=istanbul&id=SGE-getJournalEntry_N

[chrismarriott]

Perfect - thank you!

Chris