Class DBC.ChatSessionFields
Fields for ChatSession, This table contains chat sessions.
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class ChatSessionFields
Fields
AlertLevel
ChatSession.AlertLevel: The alert level for this chat session.
Declaration
public const string AlertLevel = "alert_level"
Field Value
Type | Description |
---|---|
String |
ChatbotIsactive
ChatSession.ChatbotIsactive: Indicates that a chatbot is active on the session. This will cause bot triggers to fire. Set to 0 when bot hands off to user.
Declaration
public const string ChatbotIsactive = "chatbot_isactive"
Field Value
Type | Description |
---|---|
String |
ChatSessionId
ChatSession.ChatSessionId: The primary key (auto-incremented)
Declaration
public const string ChatSessionId = "id"
Field Value
Type | Description |
---|---|
String |
CompanyName
ChatSession.CompanyName: The name of the customers company, if provided
Declaration
public const string CompanyName = "company_name"
Field Value
Type | Description |
---|---|
String |
Consented
ChatSession.Consented: The customer consented when starting the session
Declaration
public const string Consented = "consented"
Field Value
Type | Description |
---|---|
String |
ContactId
ChatSession.ContactId: The contact that this chat session is connected to
Declaration
public const string ContactId = "contact_id"
Field Value
Type | Description |
---|---|
String |
Country
ChatSession.Country: The country that the chat customer selected.
Declaration
public const string Country = "country"
Field Value
Type | Description |
---|---|
String |
CustomerAlias
ChatSession.CustomerAlias: The alias for the customer.
Declaration
public const string CustomerAlias = "customer_alias"
Field Value
Type | Description |
---|---|
String |
CustomerFetch
ChatSession.CustomerFetch: The last time the customer's client refetched the data. Used to detect 'dead' session.
Declaration
public const string CustomerFetch = "customer_fetch"
Field Value
Type | Description |
---|---|
String |
CustomerHost
ChatSession.CustomerHost: The hostname or IP address for the customer.
Declaration
public const string CustomerHost = "customer_host"
Field Value
Type | Description |
---|---|
String |
CustomerId
ChatSession.CustomerId: The reference to the associated customer. May be NULL or -1.
Declaration
public const string CustomerId = "customer_id"
Field Value
Type | Description |
---|---|
String |
ChatSession.Email: The email address of the customer, if provided
Declaration
public const string Email = "email"
Field Value
Type | Description |
---|---|
String |
FirstMessage
ChatSession.FirstMessage: A copy of the first message in the chat session
Declaration
public const string FirstMessage = "first_message"
Field Value
Type | Description |
---|---|
String |
Flags
ChatSession.Flags: Various flags for the chat session
Declaration
public const string Flags = "flags"
Field Value
Type | Description |
---|---|
String |
Idle
ChatSession.Idle: The last time anyone sent a message for this session.
Declaration
public const string Idle = "idle"
Field Value
Type | Description |
---|---|
String |
InitialQueuePos
ChatSession.InitialQueuePos: The initial queue pos (i.e. the number of pending sessions + 1) when the session was requested.
Declaration
public const string InitialQueuePos = "initial_queue_pos"
Field Value
Type | Description |
---|---|
String |
LastMessage
ChatSession.LastMessage: A copy of the last message in the chat session
Declaration
public const string LastMessage = "last_message"
Field Value
Type | Description |
---|---|
String |
Name
ChatSession.Name: The name of customer, if provided
Declaration
public const string Name = "name"
Field Value
Type | Description |
---|---|
String |
Phone
ChatSession.Phone: The phone number of the customer, if provided
Declaration
public const string Phone = "phone"
Field Value
Type | Description |
---|---|
String |
ProjectId
ChatSession.ProjectId: The project that this chat session is connected to
Declaration
public const string ProjectId = "project_id"
Field Value
Type | Description |
---|---|
String |
Rank
ChatSession.Rank: Lowest possible unique number for active sessions for user. User for color index. Starting at 1.
Declaration
public const string Rank = "rank"
Field Value
Type | Description |
---|---|
String |
SaleId
ChatSession.SaleId: The sale that this chat session is connected to
Declaration
public const string SaleId = "sale_id"
Field Value
Type | Description |
---|---|
String |
SessionKey
ChatSession.SessionKey: Key used to authenticate the session.
Declaration
public const string SessionKey = "session_key"
Field Value
Type | Description |
---|---|
String |
Status
ChatSession.Status: Enum indicating the status for the session (pending, active, closed, etc).
Declaration
public const string Status = "status"
Field Value
Type | Description |
---|---|
String |
TicketId
ChatSession.TicketId: The ticket that this chat session is connected to
Declaration
public const string TicketId = "ticket_id"
Field Value
Type | Description |
---|---|
String |
TopicId
ChatSession.TopicId: The reference to the associated chat topic.
Declaration
public const string TopicId = "topic_id"
Field Value
Type | Description |
---|---|
String |
TransferTo
ChatSession.TransferTo: The ejuser that has a pending transfer of the chat session
Declaration
public const string TransferTo = "transfer_to"
Field Value
Type | Description |
---|---|
String |
UserId
ChatSession.UserId: The reference to the associated user.
Declaration
public const string UserId = "user_id"
Field Value
Type | Description |
---|---|
String |
WhenEnded
ChatSession.WhenEnded: When the session was ended.
Declaration
public const string WhenEnded = "when_ended"
Field Value
Type | Description |
---|---|
String |
WhenRequested
ChatSession.WhenRequested: When the session was requested by the customer.
Declaration
public const string WhenRequested = "when_requested"
Field Value
Type | Description |
---|---|
String |
WhenStarted
ChatSession.WhenStarted: When the session was accepted by a user.
Declaration
public const string WhenStarted = "when_started"
Field Value
Type | Description |
---|---|
String |