TicketConversations: Freshdesk
read only
- Katalog:
Freshdesk - Schema:
Views
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle TicketConversations sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
body |
varchar2 |
Body | Content of the conversation in HTML. | ||
body_ |
varchar2 |
Haupttext | Content of the conversation in plain text. | ||
created_ |
datetime |
Erstellt bei | Date/time at which the record was created. | ||
from_ |
varchar2 |
Absenderadresse | |||
id |
int64 |
ID | ID of the conversation. | ||
incoming |
char |
Incoming | Whether a particular conversation should appear as being created from outside (i.e., not through web portal). | ||
last_ |
datetime |
itgen_freshdesk_last_edited_at | |||
last_ |
int64 |
itgen_freshdesk_last_edited_at_user_id | |||
private |
char |
Private | Whether the note is private. | ||
source |
int64 |
Source | Type of the conversation.Siehe ConversationSources. | ||
support_ |
varchar2 |
Support E-Mail-Adresse | Email address from which the reply is sent.For notes, this value will be null. | ||
ticket_ |
varchar2 |
Email address of the requester.If no contact exists with this email address in Freshdesk, it will be added as a new contact. | |||
ticket_ |
int64 |
Ticket-ID | ID of the ticket to which this conversation is being added. | ||
ticket_ |
varchar2 |
Name | Name of the requester. | ||
ticket_ |
varchar2 |
Subject | Ticket subject. | ||
updated_ |
datetime |
Aktualisiert am | Date/time at which the record was last updated. | ||
user_ |
int64 |
Benutzer-Kennung | ID of the agent/user who is adding the conversation. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: