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.