Incident management : Obtaining the date and time when additional comments were registered

[Shibayama]

This is about incident management.
After setting the assignment destination, I would like to obtain the date and time when the first additional comment was registered.

ServiceNow support gave me the following advice.

However, I have no experience with JavaScript. Can you give me some advice on the content of the script?

--Advice from support--
I think the concept should flow as follows.
1. Create a new date time field called "Temporary response date and time" in the incident
2. Create a business rule for the table as additional comments will be saved in sys_journal_field

The contents of the business rule are as follows.
1. Executed at insert time
2. In the case of an incident and a comment, check if there is another comment with the same Element ID in sys_journal_field, and if there is not, set a "temporary response date and time" for the incident.

[Maik Skoddow]

Hi @Shibayama 

you wrote, "After setting the assignment destination, I would like to obtain the date and time when the first additional comment was registered."

However, how exactly do you want to obtain that value? Do you want to see it in the form view or list view? Do you need it in reports?

Maik

[Shibayama]

@Maik Skoddow 
Thank you for answering.

I would like to display it in a list view and eventually export it to Excel format.