WorkspaceTeams
Get the teams subscribed to the workspace.
View-Specific Information
SELECT
The add-in uses the Monday API to process some of the filters. The add-in processes other filters client-side within the add-in. 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.
- WorkspaceId supports the '=' comparison operator.
- Kind supports the '=' comparison operator.
SELECT * FROM WorkspaceTeams WHERE Kind='owner'
SELECT * FROM WorkspaceTeams WorkspaceId='3820334'
INSERT
INSERT statements are mapped to the 'add_teams_to_workspace' GraphQL mutation.
The following inputs can be used in INSERT statements:
Id, WorkspaceId, Kind
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','subscriber')
INSERT INTO WorkspaceTeams (Id,WorkspaceId,Kind) VALUES ('961021','3820334','owner')
DELETE
DELETE statements are mapped to the 'delete_teams_from_workspace' GraphQL mutation.
You can delete entries by specifying the Id and WorkspaceId.
DELETE FROM WorkspaceTeams WHERE Id='961021' AND WorkspaceId='3820334'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | False |
The team's unique identifier. | |
WorkspaceId [KEY] | String | False |
The workspace's unique identifier. | |
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. |