The board's visible columns.

Table-Specific Information

SELECT

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

• Id supports the '=','IN' comparison operators.
• BoardId supports the '=','IN' comparison operator.
• Type supports the '=','IN' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Columns WHERE Id = 'name'
SELECT * FROM Columns WHERE Id IN ('name', 'status')

INSERT

The following inputs can be used in INSERT statements:

Id, BoardId, Settings, Title, Description, Type, AfterColumnId

INSERT INTO Columns (BoardId,Id,Type) VALUES ('3820334','custom_column_id_123','status')

UPDATE

The following inputs can be used in UPDATE statements (note that due to API limitations only one column's value can be updated per statement):

Title, Description

UPDATE Columns SET Title='AnotherName' WHERE Id='name' AND BoardId='3820334'

DELETE

You can delete entries by specifying the Id and BoardId.

DELETE FROM Boards WHERE Id='test' AND BoardId='3820334'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The column's identifier, unique only to its board.
BoardId [KEY]	String	False	Boards.Id	The unique identifier of the board.
Archived	Bool	False		Whether or not the column is archived.
Settings	String	False		The column's settings in a string form.
Title	String	False		The column's title.
Description	String	False		The column's description.
Type	String	False		The column's type.
Width	Int	False		The column's width.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name	Type	Description
AfterColumnId	String	The column's unique identifier after which the new column will be inserted.