Get a collection of boards.

Table Specific Information

The adapter uses the API to process some of the filters. The adapter processes other filters client-side within the adapter. 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. For example, the following queries are processed server side.

• Id supports the '=, IN' operators.
• BoardKind supports the '=' operators.

SELECT

SELECT * FROM Boards WHERE Id = '2182296646'
SELECT * FROM Boards WHERE Id IN ('2307103055','2182296646','2181960030')
SELECT * FROM Boards WHERE Id IN ('2307103055','2182296646','2181960030') AND BoardKind = 'public'
SELECT * FROM Boards WHERE BoardKind = 'public'

Columns

Name	Type	References	Description
Id [KEY]	Long		The unique identifier of the board.
TopGroupId	String	Groups.Id	The group's unique identifier.
Name	String		The board's name.
ItemsCount	Int		The number of items on the board.
Description	String		The board's description.
UpdatedAt	Datetime		The last time the board was updated at.
BoardKind	String		The board's kind (public / private / share).
BoardFolderId	Int		The board's folder unique identifier.
Communication	String		Get the board communication value - typically meeting ID.
Permissions	String		The board's permissions.
Pos	String		The board's position.
TagsIds	String		A comma separated list of the tags' unique identifiers.
State	String		The board's state (all / active / archived / deleted).
WorkspaceId	Int		The board's workspace unique identifier (null for main workspace).
WorkspaceName	String		The board's workspace name.
WorkspaceKind	String		Will return Open for Open Workspaces, and Closed for Closed Workspaces.
WorkspaceDescription	String		The board's workspace description.