ODBC Driver for Microsoft Planner

Build 23.0.8839

PlanDetails

The PlanDetails resource provides methods that allow you to manage plan details for the account.

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 本製品.

  • PlanId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM PlanDetails WHERE planId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

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 PlanDetails SET categoryDescriptions_category1 = 'Cat#1', categoryDescriptions_category2 = 'Cat#2', categoryDescriptions_category3 = 'Cat#3', categoryDescriptions_category4 = 'Cat#4', categoryDescriptions_category5 = 'Cat#5', categoryDescriptions_category6 = 'Cat#6'  WHERE PlanId = 'nETc1IDpYkmb1E17w8TxGmUAGFWC'

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
categoryDescriptions_category1 String False

categoryDescriptions_category2 String False

categoryDescriptions_category3 String False

categoryDescriptions_category4 String False

categoryDescriptions_category5 String False

categoryDescriptions_category6 String False

PlanId [KEY] String False

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