invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

ConversationMessages: Crisp Conversation Messages

read only

  • Catalogue : Crisp
  • Schéma : Views
  • Label: Conversation Messages

Permet uniquement de récupérer des données.

Colonnes de table

Les colonnes de la table ConversationMessages sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données 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.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :