Audit State Field

[Stan Martin]

I have a table that extends HR Case.  In that table is of course the State field.  I was successful in turning on auditing for that field and a record is being written to the sys_audit table, but the Old Value and New Value are blank.  Kind of defeats the purpose of auditing.

Any way to get those values to populate?

[Community Alums]

Hi @Stan Martin ,

There's a utility that can help you with that:   GlideScriptRecordUtil.   It stores the fields and values of changes on an update.

Please refer to this link to learn more : a great example of its use on ServiceNowGuru.

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Stan Martin]

Evaluator.evaluateString() problem: java.lang.SecurityException: GlideScriptRecordUtil is not allowed in scoped applications: com.glide.script.fencing.GlidePackageScopeHandler.found(GlidePackageScopeHandler.java:28)

As usual with ServiceNow, the good stuff won't work in a scoped app.

[shloke04]

Hi @Stan Martin 

As far as I know , this should work for you. 

Couple of points to note here, when you switched on the Auditing, where have you done that?

Reason for checking this is because when you extend a Table from HR Case, state is a field which is coming from task table, so the correct way of to switch on Audit for your custom table will be as below:

1) Open your Custom table form and then Right click on the State Field and then select Configure-->Dictionary and then scroll down to the Related List named as "Dictionary Override" as shown below:

Now click on New and create a Entry for your Custom Table and update the attribute as below:

audit = true;

Have you tried this way? If yes, can you share screenshot of the Audit table where it is coming as blank?

Please refer to below HI article as well which may be helpful in this scenario:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0723730

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Stan Martin]

The exact same steps I took when I turned on auditing for that field.  This is a screenshot of the Dictionary Override entry.