How to catch additional comments / work notes text value

[Ernesto di San1]

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>:

<comment>

<date/time> - <user>:

<comment>

...

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 · Accepted solution]

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.

[Ernesto di San1]

Hi Nireesha,

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

Tnx again

Ernesto