JDBC Driver for Monday

Build 22.0.8462

Boards

Get a collection of boards.

Table Specific Information

The driver uses the Monday API to process some of the filters. The driver processes other filters client-side within the driver. 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462