Memberships
Lists all members associated with the boards.
Table-Specific Information
Select
The adapter pushes supported filters in the WHERE clause to the Trello API. Remaining filters are applied client-side in the driver. For example, the following query is processed server-side:
SELECT * FROM Memberships WHERE BoardId = '4e99eb7aa9797361bc22e6ct'
For queries without a WHERE clause, such as SELECT * FROM Memberships, the results depend on whether BoardId is set.
- If BoardId is not specified, the query returns all members from all boards.
- If BoardId is specified, the query returns only the members associated with that board.
Delete
Use DELETE statements to remove records from this table.
DELETE FROM Memberships WHERE MemberID = '64526212ef0c012e35d417b7';
DELETE FROM Memberships WHERE MemberID = '64526212ef0c012e35d417b7' AND BoardId = '670f861eec1d821ddba24a6e';
Columns
| Name | Type | ReadOnly | Description |
| MemberId [KEY] | String | True |
The Id of the member. |
| FullName | String | True |
The full name of the member. |
| UserName | String | True |
The username of the member. |
| OrganizationID | String | True |
The Id of the organization where the member is part of. |
| BoardID [KEY] | String | True |
The Id of the board that the member is part of. |