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

Sub-statuses

  • Article
  • 3 minutes to read

Details

Table ID: h_itsm_statuses

Contains information about sub-statuses as well as which Service and tequest type they're associated to

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Actions Allowed
h_actions_allowed
 The data of the request actions allowed when this status is applied stored as JSON
Type LONGTEXT
Nullable true
Allow use on Automatic Status change
h_allow_use_on_auto_update
 Whether to allow automated changes to the status on a request when this status is in use
Type INTEGER
Nullable true
Customer Label
h_customer_label
 The Customer facing label of the status
Type VARCHAR
Size 199
Nullable true
Date Created
h_date_created
 The creation date of the record.
Type DATETIME
Nullable true
Date Published
h_date_published
 The Day and Time of the of when the status was published
Type DATETIME
Nullable true
Date Updated
h_last_updated
 The Day and Time of the of when the status was last updated
Type DATETIME
Nullable true
Default Language
h_default_language
 The Default fallback Language of the status
Type VARCHAR
Size 64
Nullable true
Enable selection of supplier on status change
h_supplier_enabled
 Whether to enable selection of a supplier on changes to the status on a request
Type INTEGER
Nullable true
ID
h_id
 The ID of the Status Entry
Type INTEGER
Nullable false
Primary Key true
Language
h_language
 Current Language of the Status
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
Parent Status
h_parent_status
 The Primary Status (New - Open - Resolved etc) that this sub-status belongs to
Type VARCHAR
Size 64
Nullable true
Indexed true
Pause Timers Indefinitely
h_pause_indef
 Whether to pause SLA timers indefinitely against a request when this status is applied
Type INTEGER
Nullable true
Published By
h_publishedby_userid
 The user who published the record.
Type VARCHAR
Size 100
Nullable true
Reason Required
h_reason_required
 Whether a reason needs to be supplied against a request when this status is applied
Type SMALLINT
Size 4
Nullable true
Request Type
h_request_type
 The Request Type this status is linked to
Type VARCHAR
Size 64
Nullable true
Indexed true
Service Id
h_service_id
 The Service ID the Status is linked to
Type INTEGER
Nullable true
Indexed true
Service Id
h_service_name
 The Service Name the Status is linked to
Type VARCHAR
Size 200
Nullable true
Status Id
h_status_id
 The default status ID this Status is linked to
Type INTEGER
Nullable true
Indexed true
Status Name
h_name
 The Name of the status
Type VARCHAR
Size 64
Nullable true
Indexed true
Sub-status Status
h_status
 The status of the Sub-status, whether it is Draft, Published or Retired
Type LONGTEXT
Nullable true
Timeline Visibility
h_timeline_visibility
 The visibility level for the timeline entry added on sub-status change
Type VARCHAR
Size 32
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document