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

Requests Extended

  • Article
  • 6 minutes to read

Details

Table ID: h_sm_requests_extended

Additional information related to a Request

Table Attributes

Name Value
Primary Key h_request_id

Columns

Name & ID Description Column Attributes Relationships
Chat transcript
h_chat_transcript
 The transcript of the chat when a request is raised from a Live Chat session
Type LONGTEXT
Nullable true
Custom 1
h_custom_1
 Custom Field 1
Type VARCHAR
Size 255
Nullable true
Custom 10
h_custom_10
 Custom Field 10
Type VARCHAR
Size 255
Nullable true
Custom 11
h_custom_11
 Custom Field 11
Type VARCHAR
Size 255
Nullable true
Custom 12
h_custom_12
 Custom Field 12
Type VARCHAR
Size 255
Nullable true
Custom 13
h_custom_13
 Custom Field 13
Type VARCHAR
Size 255
Nullable true
Custom 14
h_custom_14
 Custom Field 14
Type VARCHAR
Size 255
Nullable true
Custom 15
h_custom_15
 Custom Field 15
Type VARCHAR
Size 255
Nullable true
Custom 16
h_custom_16
 Custom Field 16
Type LONGTEXT
Nullable true
Custom 17
h_custom_17
 Custom Field 17
Type LONGTEXT
Nullable true
Custom 18
h_custom_18
 Custom Field 18
Type LONGTEXT
Nullable true
Custom 19
h_custom_19
 Custom Field 19
Type LONGTEXT
Nullable true
Custom 2
h_custom_2
 Custom Field 2
Type VARCHAR
Size 255
Nullable true
Custom 20
h_custom_20
 Custom Field 20
Type LONGTEXT
Nullable true
Custom 21
h_custom_21
 Custom Field 21
Type DATETIME
Nullable true
Custom 22
h_custom_22
 Custom Field 22
Type DATETIME
Nullable true
Custom 23
h_custom_23
 Custom Field 23
Type DATETIME
Nullable true
Custom 24
h_custom_24
 Custom Field 24
Type DATETIME
Nullable true
Custom 25
h_custom_25
 Custom Field 25
Type DATETIME
Nullable true
Custom 26
h_custom_26
 Custom Field 26
Type INTEGER
Nullable true
Custom 27
h_custom_27
 Custom Field 27
Type INTEGER
Nullable true
Custom 28
h_custom_28
 Custom Field 28
Type INTEGER
Nullable true
Custom 29
h_custom_29
 Custom Field 29
Type INTEGER
Nullable true
Custom 3
h_custom_3
 Custom Field 3
Type VARCHAR
Size 255
Nullable true
Custom 30
h_custom_30
 Custom Field 30
Type INTEGER
Nullable true
Custom 31
h_custom_31
 Custom Field 31
Type LONGTEXT
Nullable true
Custom 32
h_custom_32
 Custom Field 32
Type LONGTEXT
Nullable true
Custom 33
h_custom_33
 Custom Field 33
Type LONGTEXT
Nullable true
Custom 34
h_custom_34
 Custom Field 34
Type LONGTEXT
Nullable true
Custom 35
h_custom_35
 Custom Field 35
Type LONGTEXT
Nullable true
Custom 36
h_custom_36
 Custom Field 36
Type LONGTEXT
Nullable true
Custom 37
h_custom_37
 Custom Field 37
Type LONGTEXT
Nullable true
Custom 38
h_custom_38
 Custom Field 38
Type LONGTEXT
Nullable true
Custom 39
h_custom_39
 Custom Field 39
Type LONGTEXT
Nullable true
Custom 4
h_custom_4
 Custom Field 4
Type VARCHAR
Size 255
Nullable true
Custom 40
h_custom_40
 Custom Field 40
Type LONGTEXT
Nullable true
Custom 41
h_custom_41
 Custom Field 41
Type VARCHAR
Size 255
Nullable true
Custom 42
h_custom_42
 Custom Field 42
Type VARCHAR
Size 255
Nullable true
Custom 43
h_custom_43
 Custom Field 43
Type VARCHAR
Size 255
Nullable true
Custom 44
h_custom_44
 Custom Field 44
Type VARCHAR
Size 255
Nullable true
Custom 45
h_custom_45
 Custom Field 45
Type VARCHAR
Size 255
Nullable true
Custom 46
h_custom_46
 Custom Field 46
Type VARCHAR
Size 255
Nullable true
Custom 47
h_custom_47
 Custom Field 47
Type VARCHAR
Size 255
Nullable true
Custom 48
h_custom_48
 Custom Field 48
Type VARCHAR
Size 255
Nullable true
Custom 49
h_custom_49
 Custom Field 49
Type VARCHAR
Size 255
Nullable true
Custom 5
h_custom_5
 Custom Field 5
Type VARCHAR
Size 255
Nullable true
Custom 50
h_custom_50
 Custom Field 50
Type VARCHAR
Size 255
Nullable true
Custom 51
h_custom_51
 Custom Field 51
Type VARCHAR
Size 255
Nullable true
Custom 52
h_custom_52
 Custom Field 52
Type VARCHAR
Size 255
Nullable true
Custom 53
h_custom_53
 Custom Field 53
Type VARCHAR
Size 255
Nullable true
Custom 54
h_custom_54
 Custom Field 54
Type VARCHAR
Size 255
Nullable true
Custom 55
h_custom_55
 Custom Field 55
Type VARCHAR
Size 255
Nullable true
Custom 56
h_custom_56
 Custom Field 56
Type VARCHAR
Size 255
Nullable true
Custom 57
h_custom_57
 Custom Field 57
Type VARCHAR
Size 255
Nullable true
Custom 58
h_custom_58
 Custom Field 58
Type VARCHAR
Size 255
Nullable true
Custom 59
h_custom_59
 Custom Field 59
Type VARCHAR
Size 255
Nullable true
Custom 6
h_custom_6
 Custom Field 6
Type VARCHAR
Size 255
Nullable true
Custom 60
h_custom_60
 Custom Field 60
Type VARCHAR
Size 255
Nullable true
Custom 61
h_custom_61
 Custom Field 61
Type LONGTEXT
Nullable true
Custom 62
h_custom_62
 Custom Field 62
Type LONGTEXT
Nullable true
Custom 63
h_custom_63
 Custom Field 63
Type LONGTEXT
Nullable true
Custom 64
h_custom_64
 Custom Field 64
Type LONGTEXT
Nullable true
Custom 65
h_custom_65
 Custom Field 65
Type LONGTEXT
Nullable true
Custom 66
h_custom_66
 Custom Field 66
Type LONGTEXT
Nullable true
Custom 67
h_custom_67
 Custom Field 67
Type LONGTEXT
Nullable true
Custom 68
h_custom_68
 Custom Field 68
Type LONGTEXT
Nullable true
Custom 69
h_custom_69
 Custom Field 69
Type LONGTEXT
Nullable true
Custom 7
h_custom_7
 Custom Field 7
Type VARCHAR
Size 255
Nullable true
Custom 70
h_custom_70
 Custom Field 70
Type LONGTEXT
Nullable true
Custom 71
h_custom_71
 Custom Field 71
Type INTEGER
Nullable true
Custom 72
h_custom_72
 Custom Field 72
Type INTEGER
Nullable true
Custom 73
h_custom_73
 Custom Field 73
Type INTEGER
Nullable true
Custom 74
h_custom_74
 Custom Field 74
Type INTEGER
Nullable true
Custom 75
h_custom_75
 Custom Field 75
Type INTEGER
Nullable true
Custom 76
h_custom_76
 Custom Field 76
Type DATETIME
Nullable true
Custom 77
h_custom_77
 Custom Field 77
Type DATETIME
Nullable true
Custom 78
h_custom_78
 Custom Field 78
Type DATETIME
Nullable true
Custom 79
h_custom_79
 Custom Field 79
Type DATETIME
Nullable true
Custom 8
h_custom_8
 Custom Field 8
Type VARCHAR
Size 255
Nullable true
Custom 80
h_custom_80
 Custom Field 80
Type DATETIME
Nullable true
Custom 9
h_custom_9
 Custom Field 9
Type VARCHAR
Size 255
Nullable true
Last Updated
h_last_updated
 This stores the date time that this was last updated
Type DATETIME
Nullable true
Request ID
h_request_id
 The ID of the related request
Type VARCHAR
Size 100
Nullable false
Primary Key true
Request Type
h_request_type
 The type of request
Type VARCHAR
Size 32
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document