invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Conversations: Crisp Conversations

read only

  • Catalogus: Crisp
  • Schema: Views
  • Label: Conversations

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel Conversations worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
active_last datetime itgen_crp_active_last filters on the platform, writable Timestamp at which the user was last active.
active_now char itgen_crp_active_now filters on the platform, writable Whether user is considered active right now or not.
assigned_user_id varchar2 itgen_crp_assigned_user_id filters on the platform, writable Operator user identifier.
availability varchar2 itgen_crp_availability filters on the platform, writable Visitor availability; one of online and offline.
compose_operator_automated char itgen_crp_compose_operator_automated filters on the platform, writable Whether compose is automated or not (ie. comes from a bot).
compose_operator_excerpt varchar2 itgen_crp_compose_operator_excerpt filters on the platform, writable Message excerpt for compose state.
compose_operator_timestamp datetime itgen_crp_compose_operator_timestamp filters on the platform, writable Timestamp for compose state.
compose_operator_type varchar2 itgen_crp_compose_operator_type filters on the platform, writable Compose state type; one of start and stop.
compose_operator_user_avatar varchar2 itgen_crp_compose_operator_user_avatar filters on the platform, writable Compose user avatar.
compose_operator_user_nickname varchar2 itgen_crp_compose_operator_user_nickname filters on the platform, writable Compose user nickname.
compose_operator_user_user_id varchar2 itgen_crp_compose_operator_user_user_id filters on the platform, writable Compose user identifier.
compose_visitor_automated char itgen_crp_compose_visitor_automated filters on the platform, writable Whether compose is automated or not (ie. comes from a bot).
compose_visitor_excerpt varchar2 itgen_crp_compose_visitor_excerpt filters on the platform, writable Message excerpt for compose state.
compose_visitor_timestamp datetime itgen_crp_compose_visitor_timestamp filters on the platform, writable Timestamp for compose state.
compose_visitor_type varchar2 itgen_crp_compose_visitor_type filters on the platform, writable Compose state type; one of start and stop.
created_at datetime itgen_crp_created_at filters on the platform, writable Conversation creation timestamp.
inbox_id varchar2 itgen_crp_inbox_id filters on the platform, writable Inbox identifier.
is_blocked char itgen_crp_is_blocked filters on the platform, writable Whether session is blocked or not (block messages from visitor).
is_verified char itgen_crp_is_verified filters on the platform, writable Whether session is verified or not (user email ownership is authenticated).
last_message varchar2 itgen_crp_last_message filters on the platform, writable Last message excerpt (from visitor).
meta_address varchar2 itgen_crp_meta_address filters on the platform, writable Visitor address.
meta_avatar varchar2 itgen_crp_meta_avatar filters on the platform, writable Visitor avatar.
meta_connection_asn varchar2 itgen_crp_meta_connection_asn filters on the platform, writable Autonomous system number, derived by Crisp from the IP address.
meta_connection_isp varchar2 itgen_crp_meta_connection_isp filters on the platform, writable Name of the internet service provider, derived by Crisp from the IP address.
meta_data varchar2 itgen_crp_meta_data filters on the platform, writable Visitor data as JSON.
meta_device_geolocation_city varchar2 itgen_crp_meta_device_geolocation_city filters on the platform, writable City name.
meta_device_geolocation_coordinates_latitude decimal itgen_crp_meta_device_geolocation_coordinates_latitude filters on the platform, writable Latitude coordinate.
meta_device_geolocation_coordinates_longitude decimal itgen_crp_meta_device_geolocation_coordinates_longitude filters on the platform, writable Longitude coordinate.
meta_device_geolocation_country varchar2 itgen_crp_meta_device_geolocation_country filters on the platform, writable Country code.
meta_device_geolocation_region varchar2 itgen_crp_meta_device_geolocation_region filters on the platform, writable Region code.
meta_device_system_browser_major varchar2 itgen_crp_meta_device_system_browser_major filters on the platform, writable Browser major version (eg: version 8.1 has a major of 8).
meta_device_system_browser_name varchar2 itgen_crp_meta_device_system_browser_name filters on the platform, writable Browser name.
meta_device_system_browser_version varchar2 itgen_crp_meta_device_system_browser_version filters on the platform, writable Browser version.
meta_device_system_engine_name varchar2 itgen_crp_meta_device_system_engine_name filters on the platform, writable Engine name.
meta_device_system_engine_version varchar2 itgen_crp_meta_device_system_engine_version filters on the platform, writable Engine version.
meta_device_system_os_name varchar2 itgen_crp_meta_device_system_os_name filters on the platform, writable OS name.
meta_device_system_os_version varchar2 itgen_crp_meta_device_system_os_version filters on the platform, writable OS version.
meta_device_system_useragent varchar2 itgen_crp_meta_device_system_useragent filters on the platform, writable Visitor user agent.
meta_device_timezone int32 itgen_crp_meta_device_timezone filters on the platform, writable Visitor device time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00).
meta_email varchar2 itgen_crp_meta_email filters on the platform, writable Visitor email.
meta_ip varchar2 itgen_crp_meta_ip filters on the platform, writable Visitor IP address.
meta_nickname varchar2 itgen_crp_meta_nickname filters on the platform, writable Visitor nickname.
meta_origin varchar2 itgen_crp_meta_origin filters on the platform, writable Conversation origin; chat, email or a URN of the channel used.
meta_phone varchar2 itgen_crp_meta_phone filters on the platform, writable Visitor phone.
meta_subject varchar2 itgen_crp_meta_subject filters on the platform, writable Subject for conversation (if any).
people_id varchar2 itgen_crp_people_id filters on the platform, writable People identifier.
preview_message_excerpt varchar2 itgen_crp_preview_message_excerpt filters on the platform, writable Preview message excerpt.
preview_message_fingerprint int64 itgen_crp_preview_message_fingerprint filters on the platform, writable Preview message fingerprint.
preview_message_from varchar2 itgen_crp_preview_message_from filters on the platform, writable Preview message sender; one of user and operator.
preview_message_type varchar2 itgen_crp_preview_message_type filters on the platform, writable Preview message type.
session_id varchar2 itgen_crp_session_id filters on the platform, writable Session identifier.
state varchar2 itgen_crp_state filters on the platform, writable Conversation state; one of pending, unresolved and resolved.
status int32 itgen_crp_status filters on the platform, writable Conversation status (a numeric alias of the state; useful for sorting conversations).
topic varchar2 itgen_crp_topic filters on the platform, writable Topic for conversation (based on messages).
unread_operator int32 itgen_crp_unread_operator filters on the platform, writable Unread messages counter for operator.
unread_visitor int32 itgen_crp_unread_visitor filters on the platform, writable Unread messages counter for visitor.
updated_at datetime itgen_crp_updated_at filters on the platform, writable Conversation update timestamp.
waiting_since datetime itgen_crp_waiting_since filters on the platform, writable Conversation waiting since timestamp (if any).
website_id varchar2 itgen_crp_website_id filters on the platform, writable Website identifier.

Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: