Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Knowledge Base Articles

  • Article
  • 3 minutes to read

Details

Table ID: h_knowledge_knowledge_base_articles

Knowledge Base Articles

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Content
h_content
 The knowledge base article content
Nullable true
Type LONGTEXT
Created By
h_created_by
 The user who created the knowledge base article.
Nullable true
Type VARCHAR
Size 100
Date Created
h_date_created
 The date the knowledge base article was created
Nullable true
Type DATETIME
Date Last Modified
h_date_last_modified
 The last modified date of the knowledge base article
Nullable true
Type DATETIME
Date Published
h_date_published
 The day and time when the knowledge base article was published
Nullable true
Type DATETIME
Default Language
h_default_language
 The default language of the knowledge base article
Nullable true
Type VARCHAR
Size 64
External MD5
h_external_md5
 External MD5 for an imported record
Nullable true
Type VARCHAR
Size 32
External Reference
h_external_reference
 External Reference for an imported record
Nullable true
Type VARCHAR
Size 64
External Source
h_external_source
 Source of an imported record
Nullable true
Type VARCHAR
Size 32
Id
h_id
 The id of the knowledge base article record
Primary Key true
Nullable false
Type VARCHAR
Size 16
One to Many
KnowledgeBaseArticleApprovals
h_knowledge_knowledge_base_article_approvals.h_knowledge_base_article_id
KnowledgeBaseArticleAuditHistory
h_knowledge_knowledge_base_article_audit_history.h_knowledge_base_article_id
KnowledgeBaseArticleFeedback
h_knowledge_knowledge_base_article_feedback.h_knowledge_base_article_id
KnowledgeBaseArticleImages
h_knowledge_knowledge_base_article_images.h_knowledge_base_article_id
KnowledgeBaseArticleRelationships
h_knowledge_knowledge_base_article_relationships.h_knowledge_base_article_id
KnowledgeBaseArticleShares
h_knowledge_knowledge_base_article_shares.h_knowledge_base_article_id
KnowledgeBaseArticleTranslations
h_knowledge_knowledge_base_article_translations.h_knowledge_base_article_id
KnowledgeBaseArticleViews
h_knowledge_knowledge_base_article_views.h_knowledge_base_article_id
Knowledge Base Article Type Id
h_knowledge_base_article_type_id
 The primary key of the knowledge base article type
Nullable true
Type INTEGER
Size 11
Indexed true
Knowledge Base Topic
h_knowledge_base_topic_id
 The primary key of the associated knowledge base topic
Nullable true
Type INTEGER
Size 11
Indexed true
Knowledgebase Id
h_knowledge_base_id
 The primary key of the knowledge base that the knowledge base article is associated to
Nullable true
Type VARCHAR
Size 16
Indexed true
Last Modified By
h_last_modified_by
 The user id of the user who last modified the knowledge base article
Nullable true
Type VARCHAR
Size 100
Order
h_order
 Order of knowledge base article in the portals
Nullable true
Type INTEGER
Size 11
Owned By
h_owned_by
 The user who owns the knowledge base article.
Nullable true
Type VARCHAR
Size 100
Indexed true
Published By
h_published_by
 The user who published the record.
Nullable true
Type VARCHAR
Size 100
Review Date
h_review_date
 This stores the date that a knowledge base article is going to be reviewed.
Nullable true
Type DATETIME
Status
h_status
 The current status of the knowledge base article
Nullable true
Type VARCHAR
Size 50
Indexed true
Title
h_title
 The knowledge base article title
Type VARCHAR
Size 255
Nullable true
Version
h_version
 The current version of the knowledge base article
Nullable true
Type INTEGER
Size 11
Visibility Customer Portal
h_visibility_customer_portal
 The visibility of the knowledge base article from the customer portal
Nullable true
Type INTEGER
Size 11
Indexed true
Visibility Employee Portal
h_visibility_employee_portal
 The visibility of the knowledge base article from the employee portal
Nullable true
Type INTEGER
Size 11
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document