comments and work notes tables

[Steveanner]

Hello Community,

Anyone help me which tables the comments and work notes are stored and how to delete the comments in activity section of the record post commenting.

Thanks,

Steve An

[Jaspal Singh]

sys_journal_field is table that stores work_notes & comments

Follow link for how to delete it from Activity stream.

[asifnoor · Accepted solution]

Hi,

sys_journal_field is the table which stores the entries. And you can query this table by element_id which refers to the record you can delete it accordingly.

Mark the comment as a correct answer and also helpful if this has answered the question.

[Allen Andreas]

Hi,

Please see this support documentation for assistance: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0520375

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Allen Andreas]

Hi @Steveanner 

I'm glad you found a correct answer. I think for the most part, we all said the same thing, just in different ways. Everyone mentioned the sys_journal_field table whether directly or pointed to documentation which also spoke about that table, so I hope all of the replies were at least helpful to you.

With that said, the main thing is that it's important to understand the relationship with the journal entries and the audit records.

If you get a moment, I'd greatly recommend you review the ServiceNow Support article I linked to as it covers this relationship and more.

If any other reply was Helpful, please mark it as such.

Thanks!