Memberships
Lists all members associated with the boards.
Table Specific Information
Select
The driver will use the Trello API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. For example, the following query is processed server-side:
SELECT * FROM Memberships SELECT * FROM Memberships WHERE BoardId='4e99eb7aa9797361bc22e6ct'
If BoardId and OrganizationId are not present in the connection properties or in query ( for example,
SELECT * FROM Memberships) all members from all boards will be returned,
otherwise if BoardId is specified,
SELECT * FROM Membershipswill return all members of the board.
If OrganizationId is specified,
SELECT * FROM Membershipswill return all members of the organization.
If both properties are present,
SELECT * FROM Membershipswill return all members of the organization.
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
Columns
Name | Type | Description |
MemberId [KEY] | String | The Id of the member. |
FullName | String | The full name of the member. |
UserName | String | The username of the member. |
OrganizationID [KEY] | String | The Id of the organization where the member is part of. |
BoardID [KEY] | String | The Id of the board that the member is part of. |