Class DBC.ChatSessionFields

Fields for ChatSession, This table contains chat sessions.

Inheritance
Object
DBC.ChatSessionFields
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

Email

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