invantive documentation
Forum di supporto InvantiveAccedi / Registrati

ConversationMessages: Crisp Conversation Messages

read only

  • Catalogo: Crisp
  • Schema: Views
  • Label: Conversation Messages

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella ConversationMessages. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati Label Required Marks Documentation
automated char itgen_crp_automated filters on the platform, writable Whether the message is automated or not (ie. comes from a bot).
content varchar2 itgen_crp_content filters on the platform, writable Message content; the text itself for the types text and note, otherwise the content object as JSON.
content_duration int32 itgen_crp_content_duration filters on the platform, writable Object duration in seconds (only set for the type audio).
content_explain varchar2 itgen_crp_content_explain filters on the platform, writable Object explanatory text (only set for the type field).
content_id varchar2 itgen_crp_content_id filters on the platform, writable Object identifier (only set for the types picker and field).
content_name varchar2 itgen_crp_content_name filters on the platform, writable Object name (only set for the type file).
content_namespace varchar2 itgen_crp_content_namespace filters on the platform, writable Event namespace (only set for the type event).
content_required char itgen_crp_content_required filters on the platform, writable Whether the message must be filled before continuing (only set for the types picker and field).
content_text varchar2 itgen_crp_content_text filters on the platform, writable Object text (only set for the types picker, field, carousel and event).
content_type varchar2 itgen_crp_content_type filters on the platform, writable Object MIME type (only set for the types file, animation and audio).
content_url varchar2 itgen_crp_content_url filters on the platform, writable Object URL (only set for the types file, animation and audio).
content_value varchar2 itgen_crp_content_value filters on the platform, writable Object value (only set for the type field).
conversation_active_last datetime itgen_crp_active_last filters on the platform, writable, conversation_active_last Timestamp at which the user was last active.
conversation_created_at datetime itgen_crp_created_at filters on the platform, writable, conversation_created_at Conversation creation timestamp.
conversation_topic varchar2 itgen_crp_topic filters on the platform, writable, conversation_topic Topic for conversation (based on messages).
conversation_updated_at datetime itgen_crp_updated_at filters on the platform, writable, conversation_updated_at Conversation update timestamp.
conversation_waiting_since datetime itgen_crp_waiting_since filters on the platform, writable, conversation_waiting_since Conversation waiting since timestamp (if any).
delivered varchar2 itgen_crp_delivered filters on the platform, writable Channel in which the message has last been delivered (can be blank).
edited char itgen_crp_edited filters on the platform, writable Whether the message was edited after being sent or not.
fingerprint int64 itgen_crp_fingerprint filters on the platform, writable Unique message fingerprint.
from varchar2 itgen_crp_from filters on the platform, writable Message sender; one of user and operator.
origin varchar2 itgen_crp_origin filters on the platform, writable Message origin; chat, email or a URN of the channel used.
original_id varchar2 itgen_crp_original_id filters on the platform, writable Identifier of the original message as held by the channel it arrived on (if any).
properties varchar2 itgen_crp_properties filters on the platform, writable Arbitrary properties set on the message as JSON (if any).
read varchar2 itgen_crp_read filters on the platform, writable Channel in which the message has been read (can be blank).
session_id varchar2 itgen_crp_session_id filters on the platform, writable Session identifier.
stamped char itgen_crp_stamped filters on the platform, writable Whether the message was fully processed in the internal Crisp pipeline.
timestamp datetime itgen_crp_timestamp filters on the platform, writable Timestamp at which the message was sent.
translated char itgen_crp_translated filters on the platform, writable Whether the message was automatically translated or not.
type varchar2 itgen_crp_type filters on the platform, writable Message type; one of text, note, file, animation, audio, picker, field, carousel and event.
user_avatar varchar2 itgen_crp_user_avatar filters on the platform, writable Sending user avatar.
user_nickname varchar2 itgen_crp_user_nickname filters on the platform, writable Sending user nickname.
user_type varchar2 itgen_crp_user_type filters on the platform, writable Sending user type; one of website and participant.
user_user_id varchar2 itgen_crp_user_user_id filters on the platform, writable Sending user identifier; an operator user identifier or a session identifier.
website_id varchar2 itgen_crp_website_id filters on the platform, writable Website identifier.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: