Excel.Interfaces.DocumentTaskChangeCollectionLoadOptions interface

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Represents a collection of change records for a task.

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

assignee

For EACH ITEM in the collection: Represents the user assigned to the task for an assign change action, or the user unassigned from the task for an unassign change action.

changedBy

For EACH ITEM in the collection: Represents the identity of the user who made the task change.

commentId

For EACH ITEM in the collection: Represents the ID of the comment or comment reply to which the task change is anchored.

createdDateTime

For EACH ITEM in the collection: Represents the creation date and time of the task change record. All dates are in UTC.

dueDateTime

For EACH ITEM in the collection: Represents the task's due date and time. It is used for the setSchedule change action. It is in UTC time zone. It can be set to null to remove the due date and time. It should be set together with startDateTime to avoid conflicts.

id

For EACH ITEM in the collection: The unique GUID of the task change.

percentComplete

For EACH ITEM in the collection: Represents the task's completion percentage. It is used for the setPercentComplete change action. This is a value between 0 and 100, where 100 represents a completed task. Changing this value to 100 also completes the associated comment. Changing the completion from 100 to a lower value reactivates the associated comment.

priority

For EACH ITEM in the collection: Represents the task's priority. It is used for the setPriority change action. This is a value between 0 and 10, with 5 being the default priority if not set, and where 0 represents the highest priority.

startDateTime

For EACH ITEM in the collection: Represents the task's start date and time. It is used for the setSchedule change action. It is in UTC time zone. It can be set to null to remove the start date and time. It should be set together with dueDateTime to avoid conflicts.

title

For EACH ITEM in the collection: Represents the task's title. It is used for the setTitle change action.

type

For EACH ITEM in the collection: Represents the action type of the task change record. Some examples of action types are assign, undo, and setPriority.

undoChangeId

For EACH ITEM in the collection: Represents the DocumentTaskChange.id property that was undone for the undo change action.

Property Details

$all

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

assignee

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the user assigned to the task for an assign change action, or the user unassigned from the task for an unassign change action.

assignee?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

changedBy

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the identity of the user who made the task change.

changedBy?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

commentId

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the ID of the comment or comment reply to which the task change is anchored.

commentId?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

createdDateTime

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the creation date and time of the task change record. All dates are in UTC.

createdDateTime?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

dueDateTime

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the task's due date and time. It is used for the setSchedule change action. It is in UTC time zone. It can be set to null to remove the due date and time. It should be set together with startDateTime to avoid conflicts.

dueDateTime?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

id

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: The unique GUID of the task change.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

percentComplete

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the task's completion percentage. It is used for the setPercentComplete change action. This is a value between 0 and 100, where 100 represents a completed task. Changing this value to 100 also completes the associated comment. Changing the completion from 100 to a lower value reactivates the associated comment.

percentComplete?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

priority

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the task's priority. It is used for the setPriority change action. This is a value between 0 and 10, with 5 being the default priority if not set, and where 0 represents the highest priority.

priority?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

startDateTime

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the task's start date and time. It is used for the setSchedule change action. It is in UTC time zone. It can be set to null to remove the start date and time. It should be set together with dueDateTime to avoid conflicts.

startDateTime?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

title

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the task's title. It is used for the setTitle change action.

title?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

type

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the action type of the task change record. Some examples of action types are assign, undo, and setPriority.

type?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

undoChangeId

Note

This API is provided as a preview for developers and may change based on feedback that we receive. Do not use this API in a production environment.

For EACH ITEM in the collection: Represents the DocumentTaskChange.id property that was undone for the undo change action.

undoChangeId?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi BETA (PREVIEW ONLY) ]