Find comments by user

[VL10]

Hi,

Is it possible to setup a filter search to retrieve Work Notes that have been entered by a specific person?

Many thanks in advance.

[Laszlo Balla · Accepted solution]

You can do that on the Journal Entry table [sys_journal_field], filter for Element 'work_notes' and you can see the User ID of the User who added the work note.

[Saurav11 · Accepted solution]

Hello,

OOB there is no way to go to the incident from the element.

You can create a custom solution where you create a reference field on the sys_journal_field table and every time record is created we can update the reference field with that particular incident.

However the above is not a good solution and we should avoid it is because there are 100s of comments posted every minute so the BR will run non stop which can cause transaction issues and can delay all other scripts.

Please mark my answer as correct based on Impact.

[Laszlo Balla · Accepted solution]

You can do that on the Journal Entry table [sys_journal_field], filter for Element 'work_notes' and you can see the User ID of the User who added the work note.

[VL10]

That worked perfectly thank you very much for your quick answer!

[Saurav11]

Hello,

As suggested by the other answer you need to check on the sys_journal_field table and apply the below filter:-

Please mark answer correct/helpful based on Impact.

[VL10]

Thanks, is there a way to go to the element itself from the comment, like if the comment is on an Incident, how do I go to the incident?