ODBC Driver for Microsoft Planner

Build 24.0.9063

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9063