Tableau Connector for Microsoft Project

Build 25.0.9539

DraftTasks

Retrieve and modify draft tasks.

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 DraftTasks WHERE ProjectId = '99a38309-dc1d-eb11-bf8a-00155d9c6312'

Insert

The following is an example of inserting into the DraftTasks table: 

INSERT INTO DraftTasks (ProjectId, Finish, IsManual, Name, Notes, Start) VALUES ('68dceb1d-adac-ef11-bbda-00155df00e08', '2025-04-22', 'true', 'My new Test Task', 'Test temp Notes', '2025-04-18');

Columns

Name Type ReadOnly References Required Description
Id [KEY] String False False

ActualCostWorkPerformed Double False False

ActualDuration String False False

ActualDurationMilliseconds Int False False

ActualDurationTimeSpan Time False False

ActualOvertimeCost Double False False

ActualOvertimeWork String False False

ActualOvertimeWorkMilliseconds Int False False

ActualOvertimeWorkTimeSpan Time False False

BaselineCost Double False False

BaselineDuration String False False

BaselineDurationMilliseconds Int False False

BaselineDurationTimeSpan Time False False

BaselineFinish Datetime False False

BaselineStart Datetime False False

BaselineWork String False False

BaselineWorkMilliseconds Int False False

BaselineWorkTimeSpan Time False False

BudgetCost Double False False

BudgetedCostWorkPerformed Double False False

BudgetedCostWorkScheduled Double False False

Contact String False False

CostPerformanceIndex Double False False

CostVariance Double False False

CostVarianceAtCompletion Double False False

CostVariancePercentage Int False False

Created Datetime False False

CurrentCostVariance Double False False

DurationVariance String False False

DurationVarianceMilliseconds Int False False

DurationVarianceTimeSpan Time False False

EarliestFinish Datetime False False

EarliestStart Datetime False False

EstimateAtCompletion Double False False

ExternalProjectUid String False False

ExternalTaskUid String False False

FinishSlack String False False

FinishSlackMilliseconds Int False False

FinishSlackTimeSpan Time False False

FinishVariance String False False

FinishVarianceMilliseconds Int False False

FinishVarianceTimeSpan Time False False

FreeSlack String False False

FreeSlackMilliseconds Int False False

FreeSlackTimeSpan Time False False

IgnoreResourceCalendar Bool False False

IsCritical Bool False False

IsDurationEstimate Bool False False

IsExternalTask Bool False False

IsOverAllocated Bool False False

IsRecurring Bool False False

IsRecurringSummary Bool False False

IsRolledUp Bool False False

IsSubProject Bool False False

IsSubProjectReadOnly Bool False False

IsSubProjectScheduledFromFinish Bool False False

IsSummary Bool False False

LatestFinish Datetime False False

LatestStart Datetime False False

LevelingDelay String False False

LevelingDelayMilliseconds Int False False

LevelingDelayTimeSpan Time False False

Modified Datetime False False

Notes String False False

OutlinePosition String False False

OvertimeCost Double False False

OvertimeWork String False False

OvertimeWorkMilliseconds Int False False

OvertimeWorkTimeSpan Time False False

PercentWorkComplete Int False False

PreLevelingFinish Datetime False False

PreLevelingStart Datetime False False

RegularWork String False False

RegularWorkMilliseconds Int False False

RegularWorkTimeSpan Time False False

RemainingCost Double False False

RemainingOvertimeCost Double False False

RemainingOvertimeWork String False False

RemainingOvertimeWorkMilliseconds Int False False

RemainingOvertimeWorkTimeSpan Time False False

RemainingWork String False False

RemainingWorkMilliseconds Int False False

RemainingWorkTimeSpan Time False False

Resume Datetime False False

ScheduleCostVariance Double False False

ScheduledDuration String False False

ScheduledDurationMilliseconds Int False False

ScheduledDurationTimeSpan Time False False

ScheduledFinish Datetime False False

ScheduledStart Datetime False False

SchedulePerformanceIndex Double False False

ScheduleVariancePercentage Int False False

StartSlack String False False

StartSlackMilliseconds Int False False

StartSlackTimeSpan Time False False

StartVariance String False False

StartVarianceMilliseconds Int False False

StartVarianceTimeSpan Time False False

Stop Datetime False False

ToCompletePerformanceIndex Double False False

TotalSlack String False False

TotalSlackMilliseconds Int False False

TotalSlackTimeSpan Time False False

WorkBreakdownStructure String False False

WorkVariance String False False

WorkVarianceMilliseconds Int False False

WorkVarianceTimeSpan Time False False

SubProject_Id String True False

LinkedCustomFields String False False

LinkedSubProject String False False

ActualCost Double False False

ActualFinish Datetime False False

ActualStart Datetime False False

ActualWork String False False

ActualWorkMilliseconds Int False False

ActualWorkTimeSpan Time False False

AddAfterId String False False

BudgetWork String False False

BudgetWorkMilliseconds Int False False

BudgetWorkTimeSpan Time False False

Completion Datetime False False

ConstraintStartEnd Datetime False False

ConstraintType Int False False

Cost Double False False

Deadline Datetime False False

Duration String False False

DurationMilliseconds Int False False

DurationTimeSpan Time False False

Finish Datetime False False

FinishText String False False

FixedCost Double False False

FixedCostAccrual Int False False

IsActive Bool False False

IsEffortDriven Bool False False

IsLockedByManager Bool False False

IsManual Bool False False

IsMarked Bool False False

IsMilestone Bool False False

LevelingAdjustsAssignments Bool False False

LevelingCanSplit Bool False False

Name String False False

OutlineLevel Int False False

ParentId String False False

PercentComplete Int False False

PercentPhysicalWorkComplete Int False False

Priority Int False False

RemainingDuration String False False

RemainingDurationMilliseconds Int False False

RemainingDurationTimeSpan Time False False

Start Datetime False False

StartText String False False

TaskType Int False False

UsePercentPhysicalWorkComplete Bool False False

Work String False False

WorkMilliseconds Int False False

WorkTimeSpan Time False False

Calendar_Id String True False

Parent_Id String True False

StatusManager_Id Int True False

LinkedAssignments String False False

LinkedCalendar String False False

LinkedParent String False False

LinkedPredecessors String False False

LinkedStatusManager String False False

LinkedSuccessors String False False

ProjectId [KEY] String True False

Id of the parent. This column only supports equality (=) and IN filters.

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).

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539