BoardUsers
Get a board's subscribers.
Table-Specific Information
SELECT
The cmdlet uses the Monday API to process some of the filters. The cmdlet processes other filters client-side within the cmdlet. 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 '=','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. The allowed values are owner. |