ProjectStatusUpdates

Records project status updates, including any changes to goals or scope.

Table-Specific Information

Select

The add-in uses the GitHub API to process WHERE clause conditions that are built with the following columns and operators:

OwnerLogin supports the '=,IN' comparison operators.
ProjectNumber supports the '=,IN' comparison operators.

For example, the following queries are processed server-side:

SELECT * FROM [ProjectStatusUpdates]
SELECT * FROM [ProjectStatusUpdates] WHERE [OwnerLogin] = 'Val1'
SELECT * FROM [ProjectStatusUpdates] WHERE [ProjectNumber] = 123

The add-in processes other filters client-side within the add-in.

Insert

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

ProjectId
Body
StartDate
Status
TargetDate

INSERT INTO [ProjectStatusUpdates] ([ProjectId], [Body]) VALUES ('PVT_kwHOBTvkJ84Ad8nn', 'Test')

Update

You can use the following columns to update a record:

Body
StartDate
Status
TargetDate

UPDATE [ProjectStatusUpdates] SET [Body] = 'Test' WHERE [Id] = 'PVTSU_lAHOBTvkJ84Ad8nnzgABIoI'

Delete

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

DELETE FROM [ProjectStatusUpdates] WHERE [Id] = 'PVTSU_lAHOBTvkJ84Ad8nnzgABIoI'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		The unique node ID of the ProjectV2StatusUpdate object.
OwnerLogin	String	True		The login (username) of the owner of the project, which could be a user or organization.
ProjectId	String	True	Projects.Id	The unique node ID of the associated Project object.
ProjectNumber	Int	True	Projects.Number	The unique number assigned to the project within its scope (for example, repository, organization).
FullDatabaseId	Long	True		The primary key identifier for the status update in the database, represented as a BigInt.
Body	String	False		The main text content of the status update, describing progress or updates.
BodyHTML	String	True		The HTML-rendered version of the status update body for display purposes.
CreatedAt	Datetime	True		The date and time when the status update object was created, in ISO 8601 format.
StartDate	Date	False		The start date associated with the status update, typically indicating when progress began.
Status	String	False		The current status of the update (for example, 'in progress', 'completed', 'on hold').
TargetDate	Date	False		The target date by which the goals of the status update are expected to be achieved.
UpdatedAt	Datetime	True		The date and time when the status update object was last updated, in ISO 8601 format.