Hi @PetMat,
are you looking for a report count or your looking for a perticualr static incident ?
if your looking for reporting and analysis then its not recommend to go that way. this will cause perfomance hit alternatively you can create a before insert business rule which updates the comments/notes along with the current state of incident.
this will let you know what comment was added on which state...
AND>
if your looking for 1 or few static incidents the you can try the below script:
var incidentSysId = 'YOUR_INCIDENT_SYS_ID';
var desiredState = 'New';
var journalGr = new GlideRecord('sys_journal_field');
journalGr.addQuery('element_id', incidentSysId); // incident sys_id
journalGr.addQuery('element', 'incident');
journalGr.addQuery('field', 'comments');
journalGr.addQuery('new_value', desiredState);
journalGr.query();
while (journalGr.next()) {
var entrySysId = journalGr.getValue('sys_id');
var entryValue = journalGr.getValue('value');
var entryTimestamp = journalGr.getValue('sys_created_on');
gs.info('Entry Sys ID: ' + entrySysId + ', Value: ' + entryValue + ', Timestamp: ' + entryTimestamp);
}
I hope this helps...
☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....
