TaskDetails

Contains more information about the task.

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