ODBC Driver for GitHub

Build 24.0.9175

StatusUpdates

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

Table-Specific Information

Select

The 本製品 processes all filters client-side within the 本製品. The following query is the only one processed server-side:

SELECT * FROM [StatusUpdates]

Insert

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

  • Body
  • StartDate
  • Status
  • TargetDate

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

Update

You can use the following columns to update a record:

  • Body
  • StartDate
  • Status
  • TargetDate

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

Delete

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

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

Columns

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175