MessageReplies
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'
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. |