Difference Between Updated and Modified on field Knowledge

[mickydash2001]

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 · Accepted solution]

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

[Sandeep Rajput]

@mickydash2001 Usually both the field contains the exact same value.

[Anand Kumar P]

Hi @mickydash2001 ,

Modified On (kb_version Table)

Tracks when changes were made to the content of a specific version of a knowledge article.

• Example: If you edit the text of a knowledge article, "Modified On" will show when that change occurred for that particular version of the article.
• Updated (kb_version Table):

  Tracks when changes were made to a knowledge article, including content edits and other changes like category updates.

  • Example: If you not only edit the content but also change the category of a knowledge article, "Updated" will show when these changes happened for that version of the article.
    
    Thanks,
    Anand

[Sayali Gurav · Accepted solution]

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

[Amit Gujarathi · Accepted solution]

HI @mickydash2001 ,
I trust you are doing great.

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

1. 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.

2. 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.

3. 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.