TaskDetails
Contains more information about the task.
Table Specific Information
Select
The 本製品 will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- TaskId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaskDetails WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'
INSERT
INSERT is not supported for this table.
Update
Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.
UPDATE TaskDetails SET Description = 'Task description', previewType = 'reference' WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'
Delete
Delete is not supported for this table.
Columns
Name | Type | ReadOnly | Description |
CheckListId [KEY] | String | False |
The unique identifier of the checklist. |
TaskId [KEY] | String | False |
The unique identifier of the task. |
isChecked | Bool | False |
The value is true if the item is checked and false otherwise. |
checklist_lastModifiedBy_application_displayName | String | False |
Label Checklist Last Modified By Application Display Name corresponds to this field. |
checklist_lastModifiedBy_application_id | String | False |
Label Checklist Last Modified By Application ID corresponds to this field. |
lastModifiedDateTime | Datetime | False |
The date and time at which this is last modified. |
orderHint | String | False |
Typically used to set the relative order of items in the checklist. |
title | String | False |
The title of the checklist item. |
description | String | False |
The description of the task. |
previewType | String | False |
Typically used to set the type of preview that shows up on the task. |
references | String | False |
The collection of references on the task. |
PlanId | String | False |
The unique identifier of the plan. |