Query the list of participants, the message was sent to.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM SideConversationEventsMessageTo WHERE TicketId = 2 AND SideConversationId = '5d133b65-576c-11ee-bcb2-bdce8f618e59'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.

Columns

Name	Type	References	Description
SideConversationEventsId	String	SideConversationEvents.Id	Side Conversation Events Id.
TicketId	Integer	Tickets.Id	The parent ticket id of the side conversation.
SideConversationId	String	SideConversations.Id	The id of the side conversation the event belongs to.
UserId	Long		If the participant is an agent, the agent's user id.
Email	String		The email address of the participant.
Name	String		The name of the participant.
SlackWorkspaceId	String		If the participant is a Slack user or channel, the Slack workspace id.
SlackChannelId	String		If the participant is a Slack channel, the Slack channel id.
SupportGroupId	String		If the participant is a Support ticket, the support group id.
SupportAgentId	String		If the participant is a Support ticket, the support group id.
MSTeamsChannelId	String		If the participant is a Microsoft teams channel, the Teams channel id.