Field update count
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2022 12:24 AM
Created custom integer field on incident whose default value is 0
If any of the field other than work notes/comment is updated then the field count should increase by 1.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2022 12:41 AM
Hi,
The OOB field "Updates [sys_mod_count]" does this already and it will be available on all tables.
Please explore and use that as needed.
Thanks,
Arav
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2022 12:59 AM
True but that also count any update on comments/work notes. I want to exclude work notes and comments field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-07-2022 01:44 PM
Please check the community post below on the way to detect changes via a BR. It talks about an article on ServiceNow Guru to handle changes in Global scope and proposes an alternate method for other scopes.
https://community.servicenow.com/community?id=community_question&sys_id=33a68765db1cdbc01dcaf3231f961950
Using the logic, you may want to write a BR on incident table, add an exclusion clause if changes are only to work notes / comments and, update the new field accordingly.
On a related note, is there a strong business reason to pursue this integer field approach to track changes ?
