Capture if a custom field has been modified

[Jim]

How would I go about capturing if a custom field has been modified from when it was originally set? 

We would like to set up a measure that would check how many appointments were rescheduled so if h_custom_24 got modified after it was originally set, I have looked in the table for anything that shows this but the request changes table just seems to show owner, status and team and not the custom fields, and the audit table doesn't include the h_itsm_requests table

[Steve Giller]

You would have to store the original value twice (e.g. in h_custom_24 and h_custom_25) and then compare the current value to the unchanged version.

[Jim]

Hi @Steve Giller Thank you, although this may work if we had the date fields spare to use isn't there a table with this information in? as it does show in the timeline so surely the data exists somewhere?

[Sam P]

Not sure if this would suit your scenario however could you use Append, where the new value would be appended to the old value? 

[Steve Giller]

On 10/09/2024 at 12:45, Jim said:

isn't there a table with this information in?

No, this is stored as part of the update details action and is not something that can be reported on.

[Jim]

@Steve Giller No worries, Thank You

[Berto2002]

@Jim have you considered a 'tally'? I use this in my Problem Management reviews. Each time we have a review, I overwrite the customer fields with the dates of the next review and the last review but also add a "1" digit to another custom field. I can then tell how many times, the loop has been around (i.e. meetings have been held. You could also append your dates each time to a text field which would give you a history of the dates (albeit not in a particularly digestible format) which may be good enough for audit.

You end up with custom field with data like "1 1 1 1 1 1" which can be used in reporting packages to count or sum.