Class DBC.EjMessageFields

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

Inheritance
object
DBC.EjMessageFields
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class DBC.EjMessageFields

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