Class DBC.EjMessageFields

Fields for EjMessage, This table contains the messages listed under tickets.

Inheritance

DBC.EjMessageFields

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

public static class EjMessageFields : Object

Fields

Author

EjMessage.Author: A string representing the author of the message. Could be a user's name, or a persons email address.

Declaration

public const string Author = "author"

Field Value

Type	Description
String

Badge

EjMessage.Badge: Badge to explicitly determine how a message was generated

Declaration

public const string Badge = "badge"

Field Value

Type	Description
String

Body

EjMessage.Body: The textbody for the message.

Declaration

public const string Body = "body"

Field Value

Type	Description
String

BodyAttachment

EjMessage.BodyAttachment: If the body is too long for the database, it's stored in this attachment instead.

Declaration

public const string BodyAttachment = "body_attachment"

Field Value

Type	Description
String

ChangedAt

EjMessage.ChangedAt: When the message was changed.

Declaration

public const string ChangedAt = "changed_at"

Field Value

Type	Description
String

ChangedBy

EjMessage.ChangedBy: The id of the user who changed the message.

Declaration

public const string ChangedBy = "changed_by"

Field Value

Type	Description
String

CreatedAt

EjMessage.CreatedAt: When the message was posted.

Declaration

public const string CreatedAt = "created_at"

Field Value

Type	Description
String

CreatedBy

EjMessage.CreatedBy: The id of the user who posted the message. The value 1 (system user) for externally posted messages.

Declaration

public const string CreatedBy = "created_by"

Field Value

Type	Description
String

CustomerId

EjMessage.CustomerId: If the message was created by email or from the customer center, this field will point to that customer. -1 if the message was created by an user

Declaration

public const string CustomerId = "customer_id"

Field Value

Type	Description
String

DebugInfo

EjMessage.DebugInfo: The debug info for the message.

Declaration

public const string DebugInfo = "debug_info"

Field Value

Type	Description
String

EjMessageId

EjMessage.EjMessageId: The primary key (auto-incremented)

Declaration

public const string EjMessageId = "id"

Field Value

Type	Description
String

EmailHeader

EjMessage.EmailHeader: The email header is saved in this field as raw text

Declaration

public const string EmailHeader = "email_header"

Field Value

Type	Description
String

HtmlBody

EjMessage.HtmlBody: The html body for the message (if any).

Declaration

public const string HtmlBody = "html_body"

Field Value

Type	Description
String

HtmlBodyAttachment

EjMessage.HtmlBodyAttachment: If the htmlbody is too long for the database, it's stored in this attachment instead.

Declaration

public const string HtmlBodyAttachment = "html_body_attachment"

Field Value

Type	Description
String

HtmlBodyInlineConverted

EjMessage.HtmlBodyInlineConverted: True if the html_body has converted inline image links.

Declaration

public const string HtmlBodyInlineConverted = "html_body_inline_converted"

Field Value

Type	Description
String

Important

EjMessage.Important: If this message is important or not.

Declaration

public const string Important = "important"

Field Value

Type	Description
String

Inbox

EjMessage.Inbox: The id of the inbox entry which created this message. Note: inbox entries are regularily deleted.

Declaration

public const string Inbox = "inbox"

Field Value

Type	Description
String

Language

EjMessage.Language: The language this message is in, based on some kind of analysis

Declaration

public const string Language = "language"

Field Value

Type	Description
String

MailSorter

EjMessage.MailSorter: The name of the mail sorter used when the email was imported. Note: We must use name instead of id since the id's change every time one changes the mail sorter. :-0

Declaration

public const string MailSorter = "mail_sorter"

Field Value

Type	Description
String

MessageCategory

EjMessage.MessageCategory: Defines what kind of message this is.

Declaration

public const string MessageCategory = "message_category"

Field Value

Type	Description
String

MessageId

EjMessage.MessageId: The Message-Id header value from the email. Used for threading, i.e. connecting messages to existing tickets.

Declaration

public const string MessageId = "message_id"

Field Value

Type	Description
String

SearchTitle

EjMessage.SearchTitle: A copy of the title of the ticket, for search optimisation and simpler reporting.

Declaration

public const string SearchTitle = "search_title"

Field Value

Type	Description
String

Sentiment

EjMessage.Sentiment: Sentiment index, 100 = completely happy; -100 = suicidally unhappy; 0 = no idea

Declaration

public const string Sentiment = "sentiment"

Field Value

Type	Description
String

SentimentConfidence

EjMessage.SentimentConfidence: Confidence of sentiment index, 0 = no idea, 100 = completely sure

Declaration

public const string SentimentConfidence = "sentimentConfidence"

Field Value

Type	Description
String

Slevel

EjMessage.Slevel: The securitylevel of the message.

Declaration

public const string Slevel = "slevel"

Field Value

Type	Description
String

TicketId

EjMessage.TicketId: The ticket this message is a child of.

Declaration

public const string TicketId = "ticket_id"

Field Value

Type	Description
String

TimeCharge

EjMessage.TimeCharge: The amount of time (minutes) which should be invoiced for this message.

Declaration

public const string TimeCharge = "time_charge"

Field Value

Type	Description
String

TimeSpent

EjMessage.TimeSpent: The time spent (minutes) for this message.

Declaration

public const string TimeSpent = "time_spent"

Field Value

Type	Description
String

Type

EjMessage.Type: The type of the message (plaintext/html).

Declaration

public const string Type = "type"

Field Value

Type	Description
String