DraftTaskLinks
Retrieve and modify draft task links.
Table Specific Information
To query this table, the ProjectId must be specified either in the query's WHERE clause criteria or via the ProjectId connection property.
SELECT * FROM DraftTaskLinks WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'
Insert
The following is an example of inserting into the DraftTaskLinks table:
INSERT INTO DraftTaskLinks (ProjectID, DependencyType, LinkLagDuration, StartID, EndId) VALUES ('50ff2a89-98ac-ef11-bbda-00155df00e07', '1', '1D', '98f103ab-6a2f-f011-8198-00155df0ab12', 'b13ad7b5-6a2f-f011-8198-00155df1150b');
Columns
| Name | Type | ReadOnly | References | Required | Description |
| Id [KEY] | String | False | False | ||
| DependencyType | Int | False | False | ||
| EndId | String | False | False | ||
| LinkLagDuration | String | False | False | ||
| PredecessorTaskId | String | False | False | ||
| StartId | String | False | False | ||
| SuccessorTaskId | String | False | False | ||
| End_Id | String | True | False | ||
| Start_Id | String | True | False | ||
| LinkedEnd | String | False | False | ||
| LinkedStart | String | False | False | ||
| ProjectId [KEY] | String | True | False |
Id of the parent. This column only supports equality (=) and IN filters. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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). |