BoardTeams
Get a board's team subscribers.
View-Specific Information
SELECT
The component uses the Monday API to process some of the filters. The component processes other filters client-side within the component. 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
INSERT statements are mapped to the 'add_teams_to_board' GraphQL mutation.
The following inputs can be used in INSERT statements:
Id, BoardId, Kind
INSERT INTO BoardTeams (Id,BoardId,Kind) VALUES ('51688059','5546871560','subscriber')
DELETE
DELETE statements are mapped to the 'delete_teams_from_board' GraphQL mutation.
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. |