Quick question is there a way to post changes made on other table. I mean if value of alert record changes, I want to log those changes on incident table in work notes.I guess var gru = GlideScriptRecordUtil.get(gr); is not supported.

Answer : I was able to pass it as string to Incident and later parse it.

Thanks Mark for the above post !! :)

I was getting value as undefined when I pasted below script, I guess the val is already comprising of value of the field. I removed .getDisplayValue() from gs.addInfoMessage(changedFields[i] + ‘: ‘ + val.getDisplayValue()); and it worked like a charm.

//Display an information message for each change to the record
var gru = GlideScriptRecordUtil.get(current);
var changedFields = gru.getChangedFields(); //Get changed fields with friendly names
var changedValues = gru.getChanges(); //Get changed field values
//Convert to JavaScript Arrays
gs.include(‘j2js’);
changedFields = j2js(changedFields);
changedValues = j2js(changedValues);

//Process the changed fields
for(var i = 0; i < changedValues.length; i++){
var val = changedValues[i];
if(val.getED().getType() == -1 && val.getJournalEntry(1)){
//Print out last journal entry for journal fields
gs.addInfoMessage(val.getJournalEntry(1));
}
else{
//Print out changed field and value for everything else
gs.addInfoMessage(changedFields[i] + ': ' + val.getDisplayValue());
}
}

Quick question is there a way to post changes made on other table. I mean if value of alert record changes, I want to log those changes on incident table in work notes.I guess var gru = GlideScriptRecordUtil.get(gr); is not supported.

Good question. There’s not a way I’ve built yet but I’ve addressed this in the top comment on this thread from Brian Broadhurst. It offers a couple of suggestions for how you could do this. Not as straight-forward as it should be unfortunately.

Thank you for the quick reply. My business client has one additional question concerning the notification. Is it possible to show both the current and previous value of the fields that have been changed in the notification mail?

Yes, you would need to include an ‘if’ statement to check to see that the field name matched what you wanted to include (or exclude). In the mail script example, the ‘if’ statement would need to start directly below the ‘var field’ line and wrap around everything up-to and including the final ‘else’ statement. if(field == ‘category’ || field == ‘short_description’) would allow for just the category or short description fields for example.

Thank you very much for sharing your code. It is extremely useful.
I am particullary interested in the section about “Printing all record changes in an email notification”.

I am very interested in using these code snippets but when notifying users they are not interested in all variables. For example they don’t need information about system variables.
My question is can I limit the number variables displayed in my notification to a selection of my choice?

How would I acieve that ? I suppose with somekind of IF structure.

You can try ‘GlideRecordScriptUtil’ instead. That’s the new class name as of Calgary. I am seeing that ‘getChanges()’ is broken in Geneva even though it’s still available as a method. I’d advise you to contact ServiceNow support about that one.

Now that I shared my output of this script in Geneva, I would like to request some help! I trying to do this but in a scoped application! :), what I recieved at first instance was that GlideRecordUtil is not available for scoped applications, so I used the word ‘global’ before each statement related to GlideRecordUtil, and it almost worked!! then the output I keep recieving this:

‘Invalid object in scoped script: [JavaClass com.glide.script.GlideRecordUtil]’

I have tried so hard to make this right! and it was not possible! any ideas? how to apply the same scrip to a scoped application!? :) Thank you very much in advance! very good post!

…except for the new deprecation warnings on the Wiki! (http://wiki.servicenow.com/index.php?title=Mobile_Client_GlideForm_%28g_form%29_Scripting#Do_Not_Use_Deprecated_Methods)

Is this type of logic just something that can’t be easily achieved in mobile? (By the way, I’m specifically checking in a Client Script because I’m prompting users with a chance to cancel their submission when certain fields are changed.)