JDBC Driver for Monday

Build 22.0.8462

Groups

The board's visible groups.

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.
  • BoardId supports the '=, IN' operators.

SELECT


SELECT * FROM Groups WHERE Id = 'topics'
SELECT * FROM Groups WHERE Id IN ('topics','group_title')
SELECT * FROM Groups WHERE BoardId IN ('2182296646','21822966')
SELECT * FROM Groups WHERE BoardId = '2182296646' AND Id = 'topics'

Columns

Name Type References Description
Id [KEY] String The group's unique identifier.
BoardId [KEY] Long

Boards.Id

The unique identifier of the board.
Archived Bool Whether or not the group is archived.
Color String The group's color.
Deleted Bool Whether or not the group is deleted.
Position String The group's position in the board.
Title String The group's title.

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