ODBC Driver for Trello

Build 20.0.7587

BoardPreferences

Lists preferences of 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 BoardPreferences

SELECT * FROM BoardPreferences WHERE BoardId='5835594ee004411c6abdbfbc'
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
BoardId [KEY] String The Id of the Board.
BoardName String The Name of the Board.
PermissionLevel String Permission level of the board (private, organization, public).
HideVotes Boolean Determines if votes can be shown or not.
Voting String Determines if voting is allowed.
Comments String Determines the user level which can comment.
Invitations String Determines the user level which can invite.
SelfJoin Boolean Determines if self join is enabled.
IsTemplate Boolean Determines if the board is a template.
CardCovers Boolean Determines if cards should have covers or not.
CardAging String Determines what style the cards will get if they stay for too long in a list.
CalendarFeedEnabled Boolean Determines if the calendar feed is enabled.
Background String Background color.
BackgroundImage String Background image.
BackgroundImageScaled String Background image.
BackgroundTile String Background tile.
BackgroundBrightness String Background brightness.
BackgroundColor String Background color.
BackgroundBottomColor String Bottom background color.
BackgroundTopColor String Top background color.
CanBePublic Boolean Determines if the board can be public.
CanBeEnterprise Boolean Determines if the board can be enterprise.
CanBeOrg Boolean Determines if the board can be an organization.
CanBePrivate Boolean Determines if the board can be private.
CanInvite Boolean Determines if invitations are enabled.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587