Create, update, delete, and query threads of messages posted to a conversation.

Select

The MessageReplies table requires the ChannelId And ParentMessageId columns in the WHERE clause. Search criteria that refer to other columns are processed client-side within the driver.

For example, the following query is processed server side:

SELECT * FROM MessageReplies WHERE ChannelId = 'D71R6CSR1' AND ParentMessageId = '1234567890.123456'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

Slack allows inserts only when ChannelId, Text, and ParentMessageId are specified.

INSERT INTO MessageReplies (ChannelId, Text, ParentMessageId) VALUES ('D71R6CSR1', 'This is a message', '1234567890.123456')

Update

The MessageReplies table allows updates only for the Text field. Specify ChannelId and Id.

UPDATE MessageReplies Set Text = 'Updated message' WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456' 

Delete

MessageReplies can be deleted by providing the ChannelId and the Id of the message.

DELETE FROM MessageReplies WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Unique identifier for the messages.
ChannelId [KEY]	String	False	Conversation ID to fetch thread from.
UserId	String	True	User Id of the user who posted the reply.
Text	String	False	Reply message content.
ParentMessageId [KEY]	String	False	Unique identifier of a thread's parent message.
ReplyCount	Integer	True	The replies number for thread's parent message.
Subscribed	Boolean	True	Indicates if the user is subscribed to this channel.
LastRead	Datetime	True	The datetime for the last message the calling user has read in this channel.
UnreadCount	Integer	True	The number of members that have not read the parent message.