JDBC Driver for Monday

Build 22.0.8462

Items

Get a collection of items.

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

SELECT


SELECT * FROM Items ORDER BY CreatedAt DESC
SELECT * FROM Items WHERE Id = 2181917692
SELECT * FROM Items WHERE BoardId = '2181917679' AND ColumnId = 'text' AND ColumnValue = 'test'
SELECT * FROM Items WHERE BoardId = '2181917679' AND ColumnId = 'text' AND ColumnValue IN ('Working on it','test')

Columns

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

Boards.Id

The unique identifier of the board.
CreatorId String

Users.Id

The unique identifier of the item creator.
GroupId String

Groups.Id

The group's unique identifier.
CreatedAt Datetime The item's create date.
Name String The item's name.
Email String The item's email.
State String The item's state (all / active / archived / deleted).
UpdatedAt Datetime The item's last update date.
AssetsIds String A comma separated list of the items' assets/files unique identifiers.
ColumnId String

Columns.Id

The column's unique identifier.
ColumnValue String The column values to search items by. You can use text values for the search.
ColumnType String The column type.

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