ScheduledMessages
Query all scheduled messages.
Select
The connector 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 connector processes other search criteria client-side within the connector.
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用します。データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| TeamId | String |
Team id to list channels in, required if org token is used. |
| AsUser | String |
The Id of the user. |