Connect Support

Praveen Paleka2 · ‎08-17-2017

Hi,

I wanted to learn about the in and out working of connect support, but i didnt find the wiki docs or youtube videos helpful. Can someone please help with indepth documentation ?

i am basically want to understand how chat_queue_entry, live_profile,live_group_profile,live_message tables etc are inter-related to each other.

Thanks

keith_schaefer · ‎11-06-2017

I agree that examining these tables in the schema is helpful. But as this has not been listed as resolved, I will also try to provide some help.

"I basically want to understand how chat_queue_entry, live_profile, live_group_profile, live_message tables etc are related to each other."

A [chat_queue_entry] record is basically the culmination of a single Support chat session/conversation. It has some important fields including the state of the conversation, the queue, and a reference to the live group profile.

To expand on a couple of these fields, see below.

Queue: A reference to the specific [chat_queue] Queue to which the conversation belongs (ex: HR Support, IT Support, etc…)

Group: A [live_group_profile] reference. This is a table which pools together the members of the conversation. You will see this has a Related List of "Live Group Members." In Support conversations, the list will have references to the [live_group_member] records for the end user, agent, and even the chat queue entry (conversation) itself. Live Group Member records basically just say that 'x' [live_profile] belongs to 'y' [live_group_profile] as a group member.

The [live_profile] records are part of the Live Feed functionality, and have been leveraged for Connect. They are the pieces which clarify which users were conversing. You will see the Document field on these records will usually either be the User [sys_user] or specific Chat Queue Entry for which it was created.

[live_message] represents a record of each message typed into Connect (or Live Feed). So, a full [chat_queue_entry] typically involves several Live Messages, from both an agent and an end user. You can configure the list view of [live_message] records to get an idea of which messages were part of which conversation. Or, you can add the 'Activities' formatter to the [chat_queue_entry] form and see the messages formatted as the conversation took place.

I hope this helps to give you some extra insight on the relationships of the tables! Please let me know if I can further clarify anything I mentioned.

Thanks!

Keith S.

View solution in original post

Harsh Vardhan · ‎08-17-2017

have you gone through the doc?

https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/use/collaboration/concept/c_Con...

https://docs.servicenow.com/bundle/helsinki-servicenow-platform/page/use/collaboration/reference/r_P...

Chat queue refresh with domain separation workaround

Praveen Paleka2 · ‎08-17-2017

Thanks for your reply Harsh.

Yes, i have been through these docs but they werent helpful. i basically want to understand how chat_queue_entry, live_profile,live_group_profile,live_message tables etc are inter-related to each other.

Harsh Vardhan · ‎08-17-2017

Hi Praveen,

i would suggest try to check schema map of these tables then you will understand the relationship.

System Definition >> Tables and Columns >> search for the table that you want to know and check the schema map.

Praveen Paleka2 · ‎08-21-2017

Thanks Harsh for your replies.