CData Python Connector for SugarCRM

Build 25.0.9454

KBContents

Stores version-level content for knowledge base (KB) articles, including article body text and status metadata. This table supports version control, editorial review processes, and multi-language publication.

Columns

Name Type ReadOnly Description
Acl_Team_Names String True

The list of team names that are associated with this knowledge base (KB) content record. These names determine which teams are permitted to view or update the content.

Acl_Team_Set_Id String False

The unique identifier (Id) of the team set that is associated with this KB content record. The team set defines the complete group of teams that are granted access.

Active_Date Date False

The date when this content becomes active and available for use in the KB.

Active_Rev String True

A flag that is used to indicate whether this revision is the active (current) published version.

Approved Bool False

A Boolean field that returns a value of 'true' when the content has been approved for publication. It returns a value of 'false' when the content is still pending approval.

Assigned_User_Id String False

The Id of the user who is assigned responsibility for maintaining this content record.

Assigned_User_Name String True

The display name of the user who is assigned responsibility for this content record. This value appears in record headers and list views.

Attachment_List String True

The list of attachments that are associated with this KB content (for example, supplemental files, reference documents, or images).

Category_Id String False

The Id of the category that is associated with this content. Categories help group articles for browsing and reporting.

Category_Name String True

The display name of the category that is associated with this content. This value helps users navigate topic areas.

Commentlog String True

The log of comments and discussion notes that are associated with this content. This field supports collaboration and internal review.

Created_By String True

The Id of the user who created this KB content record. This value supports historical and audit tracking.

Created_By_Name String True

The display name of the user who created this content record. This value appears in activity and administrative review contexts.

Date_Entered Datetime True

The date and time when this content record was created. This timestamp supports chronological and audit tracking.

Date_Modified Datetime True

The date and time when this content record was last modified. This timestamp supports version review and update auditing.

Deleted Bool False

A Boolean field that returns a value of 'true' when this content record is marked as deleted. It returns a value of 'false' when the record remains active.

Description String False

A descriptive note that explains the purpose or context of this content entry. This field is often used for editorial or documentation notes.

Exp_Date Date False

The expiration date after which the content is considered outdated or no longer valid.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following this content record for updates. It returns a value of 'false' when the record is not being followed.

Id [KEY] String True

The Id of this KB content record. The system uses this Id to reference the content internally.

Is_External String True

A flag that indicates whether the content is designated for external publishing, such as customer portal visibility.

Kbarticle_Id String False

The Id of the KB article entry that is associated with this content version.

Kbarticle_Name String True

The display name of the KB article that is associated with this content version.

Kbdocument_Body String True

The full text body of the KB content, including formatted article text and embedded detail.

Kbdocument_Id String False

The Id of the full KB document record that is associated with this content.

Kbdocument_Name String True

The display name of the KB document that is associated with this content version.

Kbsapprover_Id String False

The Id of the user who approved this content version for publication.

Kbsapprover_Name String True

The display name of the user who approved this content version.

Kbscase_Id String False

The Id of a related case that is associated with this KB content when the article originated from customer support resolution.

Kbscase_Name String True

The display name of the related case that is associated with this content.

Language String False

The language that is assigned to this content version. This value supports multilingual publishing and localization.

Locked_Fields String True

The list of fields that are restricted from modification to preserve approved or published content integrity.

Modified_By_Name String True

The display name of the user who last modified this content record. This value supports change visibility and audit review.

Modified_User_Id String True

The Id of the user who most recently updated this content record. This value provides traceability for editorial or administrative changes.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the content has been marked as a favorite by the current user. It returns a value of 'false' when the content is not marked as a favorite.

Name String False

The display name or title of the KB content. This value appears in lists, search results, and article headers.

Notuseful Int True

The number of negative usefulness votes that this content has received from users.

Related_Languages String False

A list of languages in which alternate versions of this content are available. This list supports multilingual content pairing.

Revision Int True

The revision number of this content version. This value indicates version sequence in the editing and approval workflow.

Status String False

The current publication status of the content (for example, 'Draft', 'Pending Approval', 'Published', or 'Archived').

Sync_Key String True

The synchronization key that is used to align this content record with external systems or content sources.

Tag String False

The tags that are applied to this content for categorization, searching, and topic grouping.

Team_Count String False

The number of teams that are associated with this content record. This value indicates collaboration or access scope.

Team_Id String False

The Id of the primary team that is associated with this content record. The primary team determines the default access context.

Team_Name String False

The display name of the primary team that is associated with this content record.

Team_Set_Id String False

The Id of the full team set that is associated with this content record. The team set defines all teams that can view or modify the content.

Useful Int True

The number of positive usefulness votes that this content has received from users.

Usefulness_User_Vote String True

The usefulness rating or vote submitted by the current user for this content.

Viewcount Int True

The number of times this content has been viewed. This value indicates engagement and reference frequency.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454