invantive documentation
Invantive Support ForumsLog In / Sign Up

ConversationEvents: Crisp Conversation Events

read only

  • Catalog: Crisp
  • Schema: Views
  • Label: Conversation Events

Can only retrieve data.

Table Columns

The columns of the table ConversationEvents are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
color varchar2 itgen_crp_color filters on the platform, writable Colour of the event (if any); one of red, orange, yellow, green, blue, purple, pink, brown, grey and black.
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).
data varchar2 itgen_crp_data filters on the platform, writable Data of the event as JSON (if any).
session_id varchar2 itgen_crp_session_id filters on the platform, writable Session identifier.
text varchar2 itgen_crp_text filters on the platform, writable Text of the event.
timestamp datetime itgen_crp_timestamp filters on the platform, writable Timestamp at which the event was stacked.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: