BoardTeams
Get a board's team 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. 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 inconsistent data.
- BoardId supports the '=' comparison operator.
SELECT * FROM BoardTeams WHERE BoardId='5557271485'
INSERT
The following inputs can be used in INSERT statements:
Id, BoardId, Kind
INSERT INTO BoardTeams (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')
DELETE
You can delete entries by specifying the Id and BoardId.
DELETE FROM BoardTeams WHERE Id='51688059' AND BoardId='5546871560'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
Teams.Id |
The board team's unique identifier. |
BoardId [KEY] | String | False |
Boards.Id |
The unique identifier of the board. |
Kind | String | False |
The team's role: subscriber or owner. All owners are by default also subscribers. This column can be used to filter non-owners. 使用できる値は次のとおりです。owner |