Create, delete, and query reactions on items.

Table-Specific Information

SELECT

The provider processes the filters client-side within the provider.

SELECT * FROM Reactions 

SELECT * FROM Reactions WHERE Team = 'T046W75LRTK' 

Note: The Users column may contain multiple user IDs when more than one user has reacted to the same message with the same emoji. As a result, filtering the Users column with the equality (=) operator returns rows only when the specified user is the sole user in the reaction.

To retrieve all reactions where a specific user has participated (including those with multiple users), use the LIKE operator with wildcards instead:

SELECT * FROM Reactions WHERE Users LIKE '%U046AV8HU3G%'

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

INSERT

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

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

UPDATE

Slack does not support UPDATE for reactions.

DELETE

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

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

Columns