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