Difference Between Updated and Modified on field Knowledge

mickydash2001 · ‎10-03-2023

Hi All,
Can anyone please tell what is the difference between Modified On and updated field in kb_version table knowledge management and how it's different from updated date field of knowledge table itself?

Sayali Gurav · ‎10-03-2023

Hello @mickydash2001 ,

Updated:

This field tracks the date and time when any update is made to the record. This includes changes to any field within the record, such as modifying existing information or adding new data.

Modified:

This field, on the other hand, specifically indicates when a record has been modified in a way that affects its business logic or overall state. This could include changes to fields like the assignment group, state, priority, or any other field that might impact the workflow or processing of the record.

In summary, "Updated" reflects any change made to the record, while "Modified" focuses on alterations that directly affect the record's processing or workflow.

Mark helpful or correct if applicable.

Thanks & Regards,

Sayali Gurav

View solution in original post

Amit Gujarathi · ‎10-03-2023

HI @mickydash2001 ,
I trust you are doing great.

In ServiceNow, the distinction between the fields you mentioned is as follows:

Modified On (in kb_version table): This field typically captures the timestamp when any content or attribute of a specific version of a knowledge article was last modified. It's specific to the versioning system in the Knowledge Management module.
Updated (in kb_version table): While this field also captures a timestamp, it might be used to track changes to metadata or other non-content attributes of a versioned knowledge article. The exact distinction between "Modified On" and "Updated" can sometimes be nuanced and may depend on specific configurations or customizations in a given ServiceNow instance.
Updated Date (in the knowledge table): This field captures the timestamp of the last update made to the knowledge article, regardless of its version. It provides a holistic view of when the article, in any of its versions, was last updated.

Was this answer helpful?

Please consider marking it correct or helpful.

Your feedback helps us improve!

Thank you!

Regards,

Amit Gujrathi

View solution in original post

Leri Andrews · ‎11-02-2023

Interesting discussion this. What's even more fun is when you get asked 'when was this article version actually visible to the end user on the portal?' If you go by the date shown at the top of the page (updated or modified) then that's wrong.