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

Published Requests

Details

Table ID: h_itsm_published_requests

Contains information about Requests that should be published to the portals (supports translations)

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Date Created
h_date_created
The creation date of the record.
Type DATETIME
Nullable true
Default Request Language
h_default_language
The Default Language of the Request
Type VARCHAR
Size 25
Nullable true
Last Updated By
h_lastupdatedby_userid
The user who last updated the record.
Type VARCHAR
Size 100
Nullable true
Linked Published Request ID
h_published_request_id
The linked Published Request ID
Type INTEGER
Nullable true
Indexed true
Published By
h_publishedby_userid
The user who published the record.
Type VARCHAR
Size 100
Nullable true
Published Description
h_published_description
The Published Requests' description
Type LONGTEXT
Nullable true
Published Request ID
h_id
The unique Published Request ID
Type INTEGER
Nullable false
Primary Key true
Request Date Published
h_date_published
The Date/Time the Request was published
Type DATETIME
Nullable true
Request Date Updated
h_last_updated
The Date/Time the Request was last updated
Type DATETIME
Nullable true
Request Id
h_request_id
The Request Id
Type VARCHAR
Size 100
Nullable true
Indexed true
Request Language
h_language
The Language of the Request
Type VARCHAR
Size 25
Nullable true
Indexed true
Request Type
h_request_type
The Published Requests' Request Type
Type VARCHAR
Size 64
Nullable true
Service Id
h_service_name
The Service Name the Request is linked to
Type VARCHAR
Size 200
Nullable true
Service ID
h_service_id
The Service ID
Type INTEGER
Nullable true
Indexed true
Show Workaround
h_show_workaround
Sets if the workaround should be displayed in the portals
Type INTEGER
Nullable true
Status
h_status
The Status of the Request
Type VARCHAR
Size 25
Nullable true
Indexed true
Workaround
h_workaround
The Workaround for the Published Request
Type LONGTEXT
Nullable true
In This Document