JDBC Driver for Monday

Build 22.0.8462

ColumnValues

The item's column values.

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

SELECT


SELECT * FROM ColumnValues WHERE Id = 'person'
SELECT * FROM ColumnValues WHERE Id IN ('person','status')
SELECT * FROM ColumnValues WHERE ItemId IN ('2181853162','2181853151')
SELECT * FROM ColumnValues WHERE ItemId = '2181853162'
SELECT * FROM ColumnValues WHERE ItemId = '2181853162' AND Id = 'status'

Columns

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

Items.Id

The item's unique identifier.
AdditionalInfo String The column value's additional information.
Text String The column's textual value in string form.
Title String The column's title.
Type String The column's type.
Value String The column's value in json format.

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