BoardUsers
Get a board's subscribers.
Table-Specific Information
SELECT
The connector uses the Monday API to process some of the filters. The connector processes other filters client-side within the connector.
- BoardId supports the '=','IN' comparison operators.
- Kind supports the '=' comparison operator.
SELECT * FROM BoardUsers WHERE BoardId = '5525287714'
SELECT * FROM BoardUsers WHERE Kind = 'owner'
INSERT
The following inputs can be used in INSERT statements:
Id, BoardId, Kind
INSERT INTO BoardUsers (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')
DELETE
You can delete entries by specifying the Id and BoardId.
DELETE FROM BoardUsers WHERE Id = '51688059' AND BoardId = '5546871560'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
Users.Id |
The board owner's unique identifier. |
BoardId [KEY] | String | False |
Boards.Id |
The unique identifier of the board. |
Kind | String | False |
The user's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners. 使用できる値は次のとおりです。owner |