Get a collection of updates.

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 '=' comparison operator.
• ItemId supports the '=' comparison operator.

For example, the following queries are processed server side:

SELECT * FROM Updates WHERE Id = '173981152'
SELECT * FROM Updates WHERE ItemId = '1388002886'
SELECT * FROM Updates WHERE BoardId = '1388002765'

INSERT

The following inputs can be used in INSERT statements:

Body, ItemId, ParentId

INSERT INTO Updates (ItemId,Body,ParentId) VALUES ('5525287847','This is a new reply.','2553498004')

DELETE

You can delete entries by specifying the Id.

DELETE FROM Updates WHERE Id='2553512994'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The update's unique identifier.
Body	String	False		The update's html formatted body.
CreatedAt	Datetime	False		The update's creation date.
CreatorId	String	False	Users.Id	The unique identifier of the update creator.
ItemId	String	False		The update's item ID.
TextBody	String	False		The update's text body.
UpdatedAt	Datetime	False		The update's last edit date.
AssetsIds	String	False	Assets.Id	A comma separated list of the update's assets/files unique identifiers.
Replies	String	False		The update's replies.
BoardId	String	False		This column can be used to filter updates by a specific board identifier.

Pseudo-Columns

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

Name	Type	Description
ParentId	String	The parent update's unique identifier. This can be used to create a reply to an update.