Create, update, delete, and query the available messages in Slack.

Select

The Messages table requires ChannelId or SearchTerm in the WHERE clause. The 本製品 also uses the Slack API to process search criteria that refer to the Id column. The ChannelId, SearchTerm, and Id columns support server-side processing for the = operator. The 本製品 processes other search criteria client-side within the 本製品.

SELECT * FROM Messages WHERE ChannelId = 'D71R6CSR1'
SELECT * FROM Messages WHERE SearchTerm = 'text' 

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Insert

Slack allows inserts only when ChannelId and Text are specified.

INSERT INTO Messages (ChannelId, Text) VALUES ('D71R6CSR1', 'This is a message')

Update

The Messages table allows updates only for the Text field. Specify ChannelId and Id.

UPDATE Messages Set Text = 'Updated message' WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456' 

Delete

Messages can be deleted by providing the ChannelId and the Id of the message.

DELETE FROM Messages WHERE ChannelId = 'D71R6CSR1' AND Id = '1234567890.123456 

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	The Id of the message.
ChannelId [KEY]	String	False	The Id of the channel the message was posted to.
UserId	String	True	The Id of the user that posted the message.
Text	String	False	Text of the message.
AttachmentsAggregate	String	True	Attachments made to the message.
Previous2MessageId	String	True	Id of the message before the previous message in the thread of the returned record.
PreviousMessageId	String	True	Id of the message previous to the returned record.
NextMessageId	String	True	Id of the following message in the thread of the returned record.
Next2MessageId	String	True	Id of the message after the following message in the thread of the returned record.
SearchTerm	String	True	Filter by this column to retrieve all mesages that contain the word in the criteria.