Connect chat history

[Justin Abbott]

Is there a place where Connect chat conversations are saved?

I'm looking to provide a solution where managers of a given Chat Queue can see the conversation history for chats in their queue.

I've researched the chat_queue_entry table, but I was hoping a solution would exist that wouldn't require me to modify ACLs for the various chat tables.

[Bryan Tay3 · Accepted solution]

hi Justin,

have u try live_message table?

[darius_koohmare]

As mentioned the data lives in the live_message table, where a boolean field 'Chat' is true. Breaking it up by 'queue' would require a scripted ACL that compared a users membership to the the live message groups queue.

[michellelim]

Oh wow! I just looked at this table and it's very helpful. I also believe it helps us determine which comments come from Chat (while associated with a record) and which ones are written directly in the Comments field of a record.

Thanks!