Add sys_user_id to comments (sys_journal_field)

rajabhadury
Kilo Explorer

I'm integrating a third party app with ServiceNow and am looking at showing the incident comments, along with a picture of the users which made the comments. The default sys_journal_field has a "created by" field, but this is only a text field (of the first.lastname). The issue is that the first.lastname is not unique in the system, so you do not know which user will be returned if you do a lookup for the user based solely on this field.

I can add in the reference field (to sys_user) to the sys_journal_field, but am unsure of how/where to set this when a comment is created. Was wondering if anyone had any suggestions?

Much obliged
Raja

5 REPLIES 5

rajabhadury
Kilo Explorer

Ah, genius! Thanks very much Brad 🙂