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

Chat Sessions

  • Article
  • 1 minutes to read

Details

Table ID: h_lc_sessions

Contains details about each chat session.

Table Attributes

Name Value
Primary Key h_session_id

Columns

Name & ID Description Column Attributes Relationships
Agent Id
h_agent_id
 Id of the Agent that currently is assigned to the Chat Session
Nullable true
Type VARCHAR
Size 64
Agent unread count
h_agent_unread_count
 Number of messages unread by agent
Type INTEGER
Close Time
h_close_time
 Time Taken from when a chat is started to when it is closed (including the initial response time)
Nullable true
Type INTEGER
Size 10
Created On
h_created_on
 When the Chat Session was created
Nullable false
Type DATETIME
Id
h_session_id
 Session id
Primary Key true
Type VARCHAR
Size 16
One to Many
ChatSessionsMessages
h_lc_sessions_messages.h_session_id
Response Time
h_response_time
 Time Taken for an Agent to respond initially to the session
Nullable true
Type INTEGER
Size 10
Status
h_status
 Chat Session Status, 1=Waiting, 2=In Progress, 3=Solved, 99=Cancelled, 100=Expired
Nullable false
Type INTEGER
Update On
h_updated_on
 When the Chat Session was last Updated
Nullable false
Type DATETIME
User Id
h_user_id
 User Id that initiated has the Chat Session
Nullable false
Type VARCHAR
Size 64
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document