Get a collection of updates.

Table-Specific Information

SELECT

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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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