JDBC Driver for Trello

Build 23.0.8839

Memberships

Lists all members associated with the boards.

Table Specific Information

Select

The 本製品 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 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 Memberships
will return all members of the board.

If OrganizationId is specified,

SELECT * FROM Memberships
will return all members of the organization.

If both properties are present,

SELECT * FROM Memberships
will return all members of the organization.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839