Modify comment on sysapproval_approver table

[Souvick A]

Hello All,

I have a requirement to modify the comment added by system on approver form. The text of the comment need to be adjusted according to business. Can some one help how and where to find these comment text added in servicenow.

Thanks in Advance

Souvick

[Basheer]

Hi @Souvick A ,

The comments are available in sys_journal_field tables

In application navigator you can search sys_journal_field.list and press enter, it will give all the comments in the system

Go to approver and find the table and sys_id of the record.

Paste the sys_id of the record in the document_id of the sys_journal_field. You will get your comments.

[Souvick A]

Hi Basheer,

Thank you for your reply, it helped me to locate the comment part,now my real issue is to modify this comment every time a case created for the specific HR service.

Regards
Souvick

[Basheer]

Hi @Souvick A ,

Create a BR during the case creation.

You can easily get its sys_id of the record being created

Glide into the sys_journal_field table

query the record based on sys_id

modify the comments

update the journal field.

Hope you understood the solution.