Class ChatTopicTableInfo
Table 'chat_topic': This table contains chat topics.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("chat_topic")]
public class ChatTopicTableInfo : TableInfo, ICloneable
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Fields
DictionaryTableName
Conceptual name of table ChatTopic in the database dictionary: chat_topic
Declaration
public const string DictionaryTableName = "chat_topic"
Field Value
Type | Description |
---|---|
string |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Properties
AlertRecipient
Field 'alert_recipient' in table 'chat_topic': Dictionary type String[256], .NET type: string
The recipient(s) for the alert templateDeclaration
public StringFieldInfo AlertRecipient { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
AlertTemplate
Field 'alert_template' in table 'chat_topic': Dictionary type Int, .NET type: int
The reply template to use for alertingDeclaration
public Int32FieldInfo AlertTemplate { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
AlertTimeout
Field 'alert_timeout' in table 'chat_topic': Dictionary type Int, .NET type: int
The number of seconds for an unanswered session before we alertDeclaration
public Int32FieldInfo AlertTimeout { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BadgeHeader
Field 'badge_header' in table 'chat_topic': Dictionary type String[256], .NET type: string
The badge header of the chat topicDeclaration
public StringFieldInfo BadgeHeader { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotEnabled
Field 'bot_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable chatbot on this topic. Run the trigger scripts on bot events.Declaration
public UInt16FieldInfo BotEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotMessageReceivedScriptid
Field 'bot_message_received_scriptid' in table 'chat_topic': Dictionary type FK, target: Ejscript, .NET type: int
Script id to run when new messages received from customer.Declaration
public Int32FieldInfo BotMessageReceivedScriptid { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotMessageReceivedScriptid_InnerJoin_Ejscript
Generated join from the foreign key BotMessageReceivedScriptid in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> BotMessageReceivedScriptid_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotName
Field 'bot_name' in table 'chat_topic': Dictionary type String[81], .NET type: string
Chatbot nameDeclaration
public StringFieldInfo BotName { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotRegisterScriptid
Field 'bot_register_scriptid' in table 'chat_topic': Dictionary type FK, target: Ejscript, .NET type: int
Script id to register/unregister chatbot. 0 if there is no botDeclaration
public Int32FieldInfo BotRegisterScriptid { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotRegisterScriptid_InnerJoin_Ejscript
Generated join from the foreign key BotRegisterScriptid in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> BotRegisterScriptid_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotSessionChangedScriptid
Field 'bot_session_changed_scriptid' in table 'chat_topic': Dictionary type FK, target: Ejscript, .NET type: int
Script id to run when session state changes.Declaration
public Int32FieldInfo BotSessionChangedScriptid { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotSessionChangedScriptid_InnerJoin_Ejscript
Generated join from the foreign key BotSessionChangedScriptid in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> BotSessionChangedScriptid_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotSessionCreatedScriptid
Field 'bot_session_created_scriptid' in table 'chat_topic': Dictionary type FK, target: Ejscript, .NET type: int
Script id to run on new session.Declaration
public Int32FieldInfo BotSessionCreatedScriptid { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
BotSessionCreatedScriptid_InnerJoin_Ejscript
Generated join from the foreign key BotSessionCreatedScriptid in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> BotSessionCreatedScriptid_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
CategoryId
Field 'category_id' in table 'chat_topic': Dictionary type FK, target: EjCategory, .NET type: int
Category on ticket created from off-line requestDeclaration
public Int32FieldInfo CategoryId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
CategoryId_InnerJoin_EjCategory
Generated join from the foreign key CategoryId in this table, to its target table EjCategoryTableInfo.
Declaration
public TargetedInnerJoin<EjCategoryTableInfo> CategoryId_InnerJoin_EjCategory { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjCategoryTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ChatTopicId
Field 'id' in table 'chat_topic': Dictionary type PK, .NET type: int
The primary key (auto-incremented)Declaration
public Int32FieldInfo ChatTopicId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
CustomQueueText
Field 'custom_queue_text' in table 'chat_topic': Dictionary type String[256], .NET type: string
A text to be used in the queue message in the chat widget. Usage is controlled by the flags field, bit number 3Declaration
public StringFieldInfo CustomQueueText { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Description
Field 'description' in table 'chat_topic': Dictionary type String[256], .NET type: string
The descriptiong for this topic.Declaration
public StringFieldInfo Description { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
DictionaryTableNumber
Table number for table ChatTopic in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database
Declaration
public int DictionaryTableNumber { get; }
Property Value
Type | Description |
---|---|
int |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Flags
Field 'flags' in table 'chat_topic': Dictionary type Enum, .NET type: ChatTopicFlag
Flags for this topic: show popup alert?, collect consent first?, use custom message?Declaration
public ChatTopicFlagFieldInfo Flags { get; }
Property Value
Type | Description |
---|---|
ChatTopicFlagFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
FriEnabled
Field 'fri_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Fridays.Declaration
public UInt16FieldInfo FriEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
FriStart
Field 'fri_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Fridays. Only time-part is used.Declaration
public DateTimeFieldInfo FriStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
FriStop
Field 'fri_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Fridays. Only time-part is used.Declaration
public DateTimeFieldInfo FriStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
KbCategoryId
Field 'kb_category_id' in table 'chat_topic': Dictionary type FK, target: KbCategory, .NET type: int
Root folder for FAQ suggestionsDeclaration
public Int32FieldInfo KbCategoryId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
KbCategoryId_InnerJoin_KbCategory
Generated join from the foreign key KbCategoryId in this table, to its target table KbCategoryTableInfo.
Declaration
public TargetedInnerJoin<KbCategoryTableInfo> KbCategoryId_InnerJoin_KbCategory { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<KbCategoryTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LanguageId
Field 'language_id' in table 'chat_topic': Dictionary type FK, target: CustLang, .NET type: int
The reference to the associated customer language. NULL or -1 if not set.Declaration
public Int32FieldInfo LanguageId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LanguageId_InnerJoin_CustLang
Generated join from the foreign key LanguageId in this table, to its target table CustLangTableInfo.
Declaration
public TargetedInnerJoin<CustLangTableInfo> LanguageId_InnerJoin_CustLang { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<CustLangTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LastAccept
Field 'last_accept' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
The last time a session was accepted from the inside for this topic.Declaration
public DateTimeFieldInfo LastAccept { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LeftOuterJoin_ChatSession_TopicId
Generated left outer join from the primary key ChatTopicId on this table, to ChatSession.TopicId.
Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_TopicId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ChatSessionTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LeftOuterJoin_ChatTopicUser_TopicId
Generated left outer join from the primary key ChatTopicId on this table, to ChatTopicUser.TopicId.
Declaration
public TargetedLeftOuterJoin<ChatTopicUserTableInfo> LeftOuterJoin_ChatTopicUser_TopicId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ChatTopicUserTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LeftOuterJoin_Notify_ChatTopicId
Generated left outer join from the primary key ChatTopicId on this table, to Notify.ChatTopicId.
Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_ChatTopicId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<NotifyTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LunchStart
Field 'lunch_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours starts for lunch. Only time-part is used.Declaration
public DateTimeFieldInfo LunchStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
LunchStop
Field 'lunch_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stops for lunch. Only time-part is used.Declaration
public DateTimeFieldInfo LunchStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ManagerWarningChatMessage
Field 'manager_warning_chat_message' in table 'chat_topic': Dictionary type Int, .NET type: int
Contains the manager notify time in minutes for new chat messagesDeclaration
public Int32FieldInfo ManagerWarningChatMessage { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ManagerWarningNewChat
Field 'manager_warning_new_chat' in table 'chat_topic': Dictionary type Int, .NET type: int
Contains the manager notify time in minutesDeclaration
public Int32FieldInfo ManagerWarningNewChat { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
MonEnabled
Field 'mon_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Mondays.Declaration
public UInt16FieldInfo MonEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
MonStart
Field 'mon_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Mondays. Only time-part is used.Declaration
public DateTimeFieldInfo MonStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
MonStop
Field 'mon_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Mondays. Only time-part is used.Declaration
public DateTimeFieldInfo MonStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
Name
Field 'name' in table 'chat_topic': Dictionary type String[256], .NET type: string
The name of this chat topicDeclaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
OfflineFormQueueLength
Field 'offline_form_queue_length' in table 'chat_topic': Dictionary type Int, .NET type: int
The number of customers in the queue before the offline form is availableDeclaration
public Int32FieldInfo OfflineFormQueueLength { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
OfflineFormTimeLimit
Field 'offline_form_time_limit' in table 'chat_topic': Dictionary type Int, .NET type: int
The number of minutes in the queue before the offline form is availableDeclaration
public Int32FieldInfo OfflineFormTimeLimit { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
PriorityId
Field 'priority_id' in table 'chat_topic': Dictionary type FK, target: TicketPriority, .NET type: int
Priority on ticket created from off-line requestDeclaration
public Int32FieldInfo PriorityId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
PriorityId_InnerJoin_TicketPriority
Generated join from the foreign key PriorityId in this table, to its target table TicketPriorityTableInfo.
Declaration
public TargetedInnerJoin<TicketPriorityTableInfo> PriorityId_InnerJoin_TicketPriority { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TicketPriorityTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SatEnabled
Field 'sat_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Saturdays.Declaration
public UInt16FieldInfo SatEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SatStart
Field 'sat_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Saturdays. Only time-part is used.Declaration
public DateTimeFieldInfo SatStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SatStop
Field 'sat_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Saturdays. Only time-part is used.Declaration
public DateTimeFieldInfo SatStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SecondsPrAccept
Field 'seconds_pr_accept' in table 'chat_topic': Dictionary type Int, .NET type: int
The average number of seconds per accept for this topic.Declaration
public Int32FieldInfo SecondsPrAccept { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SunEnabled
Field 'sun_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Sundays.Declaration
public UInt16FieldInfo SunEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SunStart
Field 'sun_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Sundays. Only time-part is used.Declaration
public DateTimeFieldInfo SunStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
SunStop
Field 'sun_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Sundays. Only time-part is used.Declaration
public DateTimeFieldInfo SunStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ThuEnabled
Field 'thu_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Thursdays.Declaration
public UInt16FieldInfo ThuEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ThuStart
Field 'thu_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Thursdays. Only time-part is used.Declaration
public DateTimeFieldInfo ThuStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
ThuStop
Field 'thu_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Thursdays. Only time-part is used.Declaration
public DateTimeFieldInfo ThuStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
TueEnabled
Field 'tue_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Tuesdays.Declaration
public UInt16FieldInfo TueEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
TueStart
Field 'tue_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Tuesdays. Only time-part is used.Declaration
public DateTimeFieldInfo TueStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
TueStop
Field 'tue_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Tuesdays. Only time-part is used.Declaration
public DateTimeFieldInfo TueStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
TzLocationId
Field 'tzLocationId' in table 'chat_topic': Dictionary type FK, target: TZLocation, .NET type: int
Timezone used for the start/stop times for this topic.Declaration
public Int32FieldInfo TzLocationId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
TzLocationId_InnerJoin_TZLocation
Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.
Declaration
public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TZLocationTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
UseLunchHours
Field 'use_lunch_hours' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether to use lunch hours or not.Declaration
public UInt16FieldInfo UseLunchHours { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
UseOpeningHours
Field 'use_opening_hours' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether to use opening hours or not.Declaration
public UInt16FieldInfo UseOpeningHours { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WarningChatMessage
Field 'warning_chat_message' in table 'chat_topic': Dictionary type Int, .NET type: int
Contains the user notify time in minutes for new chat messagesDeclaration
public Int32FieldInfo WarningChatMessage { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WarningNewChat
Field 'warning_new_chat' in table 'chat_topic': Dictionary type Int, .NET type: int
Contains the user notify time in minutesDeclaration
public Int32FieldInfo WarningNewChat { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WedEnabled
Field 'wed_enabled' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether open on Wednesdays.Declaration
public UInt16FieldInfo WedEnabled { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WedStart
Field 'wed_start' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours start on Wednesdays. Only time-part is used.Declaration
public DateTimeFieldInfo WedStart { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WedStop
Field 'wed_stop' in table 'chat_topic': Dictionary type DateTime, .NET type: DateTime
When opening hours stop on Wednesday. Only time-part is used.Declaration
public DateTimeFieldInfo WedStop { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WelcomeMessage
Field 'welcome_message' in table 'chat_topic': Dictionary type Clob, .NET type: string
The welcome message sent to the customer when the chat session starts.Declaration
public StringFieldInfo WelcomeMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetAgentMsgColor
Field 'widget_agent_msg_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget agent messageDeclaration
public StringFieldInfo WidgetAgentMsgColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetAgentMsgTextColor
Field 'widget_agent_msg_text_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget agent message textDeclaration
public StringFieldInfo WidgetAgentMsgTextColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetAgentUseFirstname
Field 'widget_agent_use_firstname' in table 'chat_topic': Dictionary type Bool, .NET type: short
Whether to use the firstname of the agent in the chat widget.Declaration
public UInt16FieldInfo WidgetAgentUseFirstname { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetAutoFaq
Field 'widget_auto_faq' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable automatic FAQ suggestionsDeclaration
public UInt16FieldInfo WidgetAutoFaq { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetBadgeColor
Field 'widget_badge_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget badgeDeclaration
public StringFieldInfo WidgetBadgeColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetBadgeTextColor
Field 'widget_badge_text_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget badge textDeclaration
public StringFieldInfo WidgetBadgeTextColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetButtonColor
Field 'widget_button_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget buttonDeclaration
public StringFieldInfo WidgetButtonColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetButtonTextColor
Field 'widget_button_text_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget button textDeclaration
public StringFieldInfo WidgetButtonTextColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetColor
Field 'widget_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
The base color of the widgetDeclaration
public StringFieldInfo WidgetColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetCustMsgColor
Field 'widget_cust_msg_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget customer messageDeclaration
public StringFieldInfo WidgetCustMsgColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetCustMsgTextColor
Field 'widget_cust_msg_text_color' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional color for chat widget customer message textDeclaration
public StringFieldInfo WidgetCustMsgTextColor { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetEnableRating
Field 'widget_enable_rating' in table 'chat_topic': Dictionary type Bool, .NET type: short
Setting this to true will enable rating support in the chat widgetDeclaration
public UInt16FieldInfo WidgetEnableRating { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetEnableTicket
Field 'widget_enable_ticket' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable ticket submission in offline modeDeclaration
public UInt16FieldInfo WidgetEnableTicket { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetFont
Field 'widget_font' in table 'chat_topic': Dictionary type String[65], .NET type: string
The font used in the widgetDeclaration
public StringFieldInfo WidgetFont { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetFontSize
Field 'widget_font_size' in table 'chat_topic': Dictionary type String[17], .NET type: string
Optional size for chat widget fontDeclaration
public StringFieldInfo WidgetFontSize { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetLanguage
Field 'widget_language' in table 'chat_topic': Dictionary type String[64], .NET type: string
The language ISO code for the widget languageDeclaration
public StringFieldInfo WidgetLanguage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetOfflineFields
Field 'widget_offline_fields' in table 'chat_topic': Dictionary type Enum, .NET type: WidgetRequiredFields
Required field when creating ticket in offline modeDeclaration
public WidgetRequiredFieldsFieldInfo WidgetOfflineFields { get; }
Property Value
Type | Description |
---|---|
WidgetRequiredFieldsFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetOfflineHeader
Field 'widget_offline_header' in table 'chat_topic': Dictionary type String[256], .NET type: string
Offline text shown in widget headerDeclaration
public StringFieldInfo WidgetOfflineHeader { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetOfflineMessage
Field 'widget_offline_message' in table 'chat_topic': Dictionary type String[1025], .NET type: string
Offline message shown in widgetDeclaration
public StringFieldInfo WidgetOfflineMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPostForm
Field 'widget_post_form' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable post chat formDeclaration
public UInt16FieldInfo WidgetPostForm { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPostHeader
Field 'widget_post_header' in table 'chat_topic': Dictionary type String[256], .NET type: string
Header text to show in post chat formDeclaration
public StringFieldInfo WidgetPostHeader { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPostMessage
Field 'widget_post_message' in table 'chat_topic': Dictionary type String[1025], .NET type: string
Message text to show in post chat formDeclaration
public StringFieldInfo WidgetPostMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPostTranscript
Field 'widget_post_transcript' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable transcript of chat sessionDeclaration
public UInt16FieldInfo WidgetPostTranscript { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPreForm
Field 'widget_pre_form' in table 'chat_topic': Dictionary type Bool, .NET type: short
Enable pre-chat form for anonymous usersDeclaration
public UInt16FieldInfo WidgetPreForm { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetPreMessage
Field 'widget_pre_message' in table 'chat_topic': Dictionary type String[1025], .NET type: string
Message to be shown in a pre-chatDeclaration
public StringFieldInfo WidgetPreMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetRatingText
Field 'widget_rating_text' in table 'chat_topic': Dictionary type String[1025], .NET type: string
The text to be displayed in the widget next to the rating starsDeclaration
public StringFieldInfo WidgetRatingText { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetRequiredFields
Field 'widget_required_fields' in table 'chat_topic': Dictionary type Enum, .NET type: WidgetRequiredFields
Fields required to start a chatDeclaration
public WidgetRequiredFieldsFieldInfo WidgetRequiredFields { get; }
Property Value
Type | Description |
---|---|
WidgetRequiredFieldsFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetShowAgentPhoto
Field 'widget_show_agent_photo' in table 'chat_topic': Dictionary type Bool, .NET type: short
Use agent photo and name when chattingDeclaration
public UInt16FieldInfo WidgetShowAgentPhoto { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetShowLogo
Field 'widget_show_logo' in table 'chat_topic': Dictionary type Bool, .NET type: short
Indicates if the logo should be shown in the widgetDeclaration
public UInt16FieldInfo WidgetShowLogo { get; }
Property Value
Type | Description |
---|---|
UInt16FieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetTheme
Field 'widget_theme' in table 'chat_topic': Dictionary type Enum, .NET type: WidgetTheme
Predefined themes for the chat widgetDeclaration
public WidgetThemeFieldInfo WidgetTheme { get; }
Property Value
Type | Description |
---|---|
WidgetThemeFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetWelcomeMessage
Field 'widget_welcome_message' in table 'chat_topic': Dictionary type String[256], .NET type: string
Short message displayed as long as the request is in queue or activeDeclaration
public StringFieldInfo WidgetWelcomeMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().
WidgetWelcomeTitle
Field 'widget_welcome_title' in table 'chat_topic': Dictionary type String[256], .NET type: string
Short welcome message when user initiates a chatDeclaration
public StringFieldInfo WidgetWelcomeTitle { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling TablesInfo.GetChatTopicInfo().