TaskDetails
null
Table Specific Information
Select
The add-in 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 add-in.
- 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 |
isChecked | Bool | False | |
checklist_lastModifiedBy_application_displayName | String | False | |
checklist_lastModifiedBy_application_id | String | False | |
lastModifiedDateTime | Datetime | False | |
orderHint | String | False | |
title | String | False | |
description | String | False | |
previewType | String | False | |
references | String | False | |
PlanId | String | False | |
TaskId [KEY] | String | False | |
CheckListId [KEY] | String | False |