Skip to main content

Chat Conversations

DPQL Field Reference

Chat Conversation (table: chat_conversations)

Field Name Data Type
agent_id number
agent_team_id number
brand string
custom field custom_data[x]
date_assigned datetime
date_created datetime
date_ended datetime
date_first_agent_message datetime
department_id number
ended_by string
id number
is_agent boolean
is_window boolean
person_email string
person_id number
person_name string
rating_comment string
rating_overall number
rating_response_time number
session_id number
status string
subject string
total_to_ended number
visitor_id number
agent Person
agent_team Agent Team
department Department
labels Label Chat Conversation
messages Chat Message
person Person
session Session
visitor Visitor

Chat Message (table: chat_messages)

Field Name Data Type
author_id number
content string
conversation_id number
date_created datetime
id number
is_html boolean
is_sys boolean
is_user_hidden boolean
metadata string
origin string
person_name string
author Person
conversation Chat Conversation
Authors list

First published: 16/03/2017

Last updated: Feb 18, 2020 by Matthew Wray