Stages
Retrieve and modify project stages.
Table Specific Information
Insert
When inserting into the Stages table, at least one stage project details page is required to be specified.
For example:
INSERT INTO StageDetailPages#Temp (Id, Description, Position) VALUES ('6540cd17-6fc7-4483-ae02-fbc2ea262377', 'Test StageDetailPages', 1);
INSERT INTO Stages (Name, Description, WorkflowStatusPageId, PhaseId, CheckInRequired, Behavior, LinkedProjectDetailPages) VALUES ('Testing Stage2', 'The Description', '18c3e7c0-62ed-4099-912e-0b8460832cbe', 'd374d895-bccc-ef11-bbda-00155df06d03', true, 1, 'StageDetailPages#Temp');
Columns
| Name | Type | ReadOnly | References | Required | Description |
| Id [KEY] | String | False | False | ||
| Behavior | Int | False | False | ||
| CheckInRequired | Bool | False | False | ||
| Description | String | False | False | ||
| Name | String | False | False | ||
| SubmitDescription | String | False | False | ||
| Phase_Id | String | True | False | ||
| WorkflowStatusPage_Id | String | True | False | ||
| LinkedCustomFields | String | False | False | ||
| LinkedPhase | String | False | False | ||
| LinkedProjectDetailPages | String | False | False | ||
| LinkedWorkflowStatusPage | String | False | False |
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 |
| InsertMode | String |
Determines the Insert Mode. Set to 'ADD' to use standard MSProject Add function. This is the default and is recommended. Set to 'ODATA' to use standard ODATA insert functionality. This input is only applicable during inserts. The value set in this input overrides the value set in the InsertMode connection property (see the documentation page for the InsertMode connection property for more information). |