How to catch additional comments / work notes text value

Ernesto di San1 · ‎10-21-2016

Dear all,

I have created a custom field called "Activity History" into incident table, this is a string field and I'd like to use it to store all updates performed on an incident, something like the following:

<date/time> - <user>:

<date/time> - <user>:

...

Since, as far as I understood, the "Post" button near the comments field doesn't submit the form, I assume can't use Business Rules to achieve my goal... so, is there a way to catch comments value when Post button is clicked and add its content to my custom field?

Thanks in advance.

Cheers

Ernesto

nireeshareddy · ‎10-21-2016

In an out of box instance, all your additional comments and worknotes will be stored in table : "sys_journal_field"

For each entry it creates a new record in sys_journal_field table and you can retrieve the values back from the table.

View solution in original post

Ernesto di San1 · ‎10-23-2016

Hi Nireesha,

thanks for your feedback, I'll try your solution, I suppose it will work

Tnx again

Ernesto