ScheduledMessages
Query all scheduled messages.
Select
The provider 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 provider processes other search criteria client-side within the provider.
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'
Columns
| Name | Type | Description |
| Id [KEY] | String | The Id of the scheduled message. |
| ChannelId | String | The Id of the Channel. |
| PostAt | Datetime | The posted date |
| CreatedTime | Datetime | The created date. |
| Text | String | 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. |