Documentation

{{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}}

Knowledge Bases

Details

Table ID: h_knowledge_knowledge_bases

Knowledge Bases

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Created By
h_created_by
The user id of the user who created the knowledge base
Nullable true
Type VARCHAR
Size 100
Date Created
h_date_created
The date the knowledge base was created
Nullable true
Type DATETIME
Date Last Modified
h_date_last_modified
The last modified date of the knowledge base
Nullable true
Type DATETIME
Default Language
h_default_language
The default language of the knowledge base
Nullable true
Type VARCHAR
Size 64
Description
h_description
A description of the knowledge base
Nullable true
Type LONGTEXT
Editor Options
h_editor_options
The editor options for the knowledge base, stored as a JSON string
Nullable true
Type LONGTEXT
Icon
h_icon
The knowledge base icon
Nullable true
Type VARCHAR
Size 255
Id
h_id
The id of the knowledge base record
Primary Key true
Nullable false
Type VARCHAR
Size 16
One to Many
h_knowledge_knowledge_base_access.h_knowledge_base_id
h_knowledge_knowledge_base_subscriptions.h_knowledge_base_id
h_knowledge_knowledge_base_topics.h_knowledge_base_id
h_knowledge_knowledge_base_translations.h_knowledge_base_id
Last Modified By
h_last_modified_by
The user id of the user who last modified the knowledge base
Nullable true
Type VARCHAR
Size 100
Name
h_name
The knowledge base name
Nullable true
Type VARCHAR
Size 255
New Articles Require Approval
h_new_articles_require_approval
Determines if new articles created for the knowledge base require approval. 0 for no, 1 for yes
Nullable false
Type INTEGER
Size 11
Owner
h_owner
The user id of the user who owns the knowledge base
Nullable true
Type VARCHAR
Size 100
Indexed true
Status
h_status
The status of the knowledge base
Nullable true
Type VARCHAR
Size 30
Use In Customer Portal
h_use_in_customer_portal
Determins if the knowledge base is available in the customer portal. 0 for no, 1 for yes
Nullable true
Type INTEGER
Size 11
Use In Employee Portal
h_use_in_employee_portal
Determins if the knowledge base is available in the employee portal. 0 for no, 1 for yes
Nullable true
Type INTEGER
Size 11
In This Document