StatusUpdates

Logs status changes for project items, helping teams track progress and communicate updates effectively.

Table-Specific Information

The add-in processes all filters client-side within the add-in. The following query is the only one processed server-side:

SELECT * FROM [StatusUpdates]

You can use the following columns to create (insert) a new record:

INSERT INTO [StatusUpdates] ([Body]) VALUES ('Test')

You can use the following columns to update a record:

UPDATE [StatusUpdates] SET [Body] = 'Test' WHERE [Id] = 'PVTSU_lAHOBTvkJ84Ad8nnzgABIno'

You can specify the following column to delete a record: Id

DELETE FROM [StatusUpdates] WHERE [Id] = 'PVTSU_lAHOBTvkJ84Ad8nnzgABInY'


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique node ID of the ProjectV2StatusUpdate object.
FullDatabaseId	Long	True		The primary key of the status update in the database, stored as a BigInt for scalability.
Body	String	False		The textual content of the status update.
BodyHTML	String	True		The content of the status update rendered in HTML format for web display.
CreatedAt	Datetime	True		The date and time when the status update was initially created.
StartDate	Date	False		The start date associated with the status update.
Status	String	False		The current status of the status update, such as 'IN_PROGRESS' or 'COMPLETED'.
TargetDate	Date	False		The target completion date specified in the status update.
UpdatedAt	Datetime	True		The date and time when the status update was last modified.