Reactions

Create, delete, and query reactions on items.

Select

The 本製品 will use the Slack API to process search criteria that refer to the Team, Users column. This column supports server-side processing for the = operator. The 本製品 processes other filters client-side within the 本製品.

SELECT * FROM Reactions WHERE Users = 'U046AV8HU3G'

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK'

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' AND Users = 'U046AV8HU3G'

Insert

Inserts are allowed when you specify the ChannelId, Id, Name and Type. For example:

INSERT INTO Reactions (ChannelId, Id, Type, Name) VALUES ('C04HBS2PS56', '1672114112.994259', 'message', 'raised_hands')

Update

Slack does not support UPDATE for reactions.

Delete

You can delete a pin by providing the ChannelId, Id, Name and Type.

DELETE FROM Reactions WHERE Name = 'raised_hands' AND ChannelId = 'C04HBS2PS56' AND Id = '1672114112.994259' AND  type = 'message'

Columns