MessageReplies
Create, update, delete, and query threads of messages posted to a conversation.
Table Specific Information
Select
The 本製品 uses the Slack API to filter the results by the following columns and operators while the rest of the filter is executed client-side within the 本製品.
The MessageReplies table requires ChannelId and ParentMessageId columns in the WHERE clause; otherwise, the driver will automatically add these columns.
- ChannelId supports the = operator.
- ParentMessageId supports the = operator.
- CreatedTime supports the <,>,>=,<=,= operator.
- ParentCreatedTime supports the <,>,>=,<=,= operator.
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. |
CreatedTime | Datetime | True |
The created date time of the message reply. |
ParentCreatedTime | Datetime | True |
The parent message created date time. |