ScheduledMessages
Query all scheduled messages.
Select
The add-in will use the Slack API to filter by search criteria that refer to the ChannelId, PostAt and TeamId columns. All columns support server-side processing for the = operator, and the PostAt column also supports server-side processing for the >, >=, <, <= operators.
The add-in processes other search criteria client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM ScheduledMessages WHERE ChannelId = 'D064Q184VGA' SELECT * FROM ScheduledMessages WHERE TeamId = 'T01LC4ASB2M' SELECT * FROM ScheduledMessages WHERE PostAt >= '07-01-2024 00:00:00' and PostAt <= '07-31-2024 00:00:00'
Delete
Scheduled Messages can be deleted by providing the ChannelId and the Id of the scheduled message.
DELETE FROM ScheduledMessages WHERE ChannelId = 'D71R6CSR1' AND Id = 'Q07SJJT75CN'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | True |
The Id of the scheduled message. | |
| ChannelId | String | True |
The Id of the Channel. | |
| PostAt | Datetime | True |
The date the message was posted. | |
| CreatedTime | Datetime | True |
The date the message was created. | |
| Text | String | True |
The text of the scheduled message. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements. These offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| TeamId | String |
Team id to list channels in, required if org token is used. |
| AsUser | String |
The Id of the user. |