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

FAQs

Details

Table ID: h_itsm_faqs

Details of FAQs and supported translations

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Created By
h_createdby_userid
The user who created the record.
Type VARCHAR
Size 100
Nullable true
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Language
h_default_language
The Default fallback Language of the Q-A for the FAQ
Type VARCHAR
Size 64
Nullable true
FAQ Answer
h_answer
The FAQ Answer
Type LONGTEXT
Nullable true
FAQ Date Published
h_date_published
The Day and Time of the of when the FAQ was published
Type DATETIME
Nullable true
FAQ Date Updated
h_last_updated
The Day and Time of the of when the FAQ was last updated
Type DATETIME
Nullable true
FAQ Id
h_faq_id
The FAQ ID
Type INTEGER
Nullable true
Indexed true
FAQ Question
h_question
The FAQ Question
Type VARCHAR
Size 255
Nullable true
FAQ Status
h_status
The current status of the FAQ
Type VARCHAR
Size 50
Nullable true
Indexed true
FAQ Visibility
h_visibility
The visibility of the FAQ. The options are portals, serviceDesk or both.
Type VARCHAR
Size 64
Nullable true
Indexed true
Feedback Count
h_feedback_count
The tally of the Feedback Count
Type INTEGER
Nullable true
Feedback Dislikes
h_feedback_dislikes
The tally of the Feedback Dislikes
Type INTEGER
Nullable true
Feedback Likes
h_feedback_likes
The tally of the Feedback Likes
Type INTEGER
Nullable true
ID
h_id
The ID of the FAQ
Type INTEGER
Nullable false
Primary Key true
Language
h_language
Current Language of the Q-A for the FAQ
Type VARCHAR
Size 64
Nullable true
Indexed true
Last Updated By
h_lastupdatedby_userid
The user who last updated the record.
Type VARCHAR
Size 100
Nullable true
Media Link
h_media_link
Link for the Media - YouTube video
Type LONGTEXT
Nullable true
Order
h_order
Order of FAQs in the Portals
Type INTEGER
Nullable true
Portal Usage
h_portal_usage
The areas in the portals (employee and customer) the article will be returned
Type VARCHAR
Size 64
Nullable true
Indexed true
Published By
h_publishedby_userid
The user who published the record.
Type VARCHAR
Size 100
Nullable true
Service Desk Usage
h_desk_usage
The areas in the service desk the article will be returned
Type VARCHAR
Size 64
Nullable true
Indexed true
Service Id
h_service_id
The Service ID the FAQ is linked to
Type INTEGER
Nullable true
Indexed true
Service Id
h_service_name
The Service Name the FAQ is linked to
Type VARCHAR
Size 200
Nullable true
Views Count
h_view_count
Number of users who have viewed the FAQ
Type INTEGER
Nullable true
In This Document