Show changes to record since last opened

[inatherese]

Hi,

I am wondering if there is a way to know if there has been an update to a record since the last time it was opened?

For example if I need a record to be marked a certain color in a list if it has been updated since the last time I looked at it.

Or if there are any other suggestions as to how I can accomodate the same need, these will be gladly accepted.

Might be many ideas and fixes for this already out there, but I found the topic difficult to search for.

Thanks!

[inatherese]

I see that I say "open" and "close" in step one, I only mean open as in viewing an incident, and closing as in exiting it, not changing the state of it.

[Abhinandan Pati]

Hi Ina,

I think you are not looking for   OOB 'Updated'/'Updated by'   system fields but you are looking for 'Last viewed'/'Last viewed by' fields. Am I correct here? If answer is YES then below solution comes to my mind.

Create 2 new fields: one should be date/time field & other should refer 'User' table & update these 2 fields in 'Display' business rule. Display rules are processed when a user requests a record form. While updating these 2 fields make use of   'autoSysFields(false);'   so that this update should not impact other system fields. You will get more information related to this in below mentioned link

GlideRecord - ServiceNow Wiki

Thanks,

Abhinandan

[Abhinandan Pati]

And I am not sure how good is this proposed solution is.There can be better solution than this.

Thanks

Abhinandan

[pravalika2]

Hi Therese,

You can make use of metrics, which could be defined on tables to capture changes made on any record. But, metrics could be written on fields which are audited.

So, when a metric is defined on a particular table, you can create metric instances based on which changes you would like to record. Scripting knowledge would be helpful.

You could refer to:

Metric Definition Support - ServiceNow Wiki

There are two types of metrics. In wiki they mentioned about "Field value duration" but not "Script calculation".

Here is a link which says about "Script Calculation"

Metric

Hope this helps

Thanks & Regards,

Poojitha