PlanDetails
The PlanDetails resource provides methods that allow you to manage plan details for the account.
Table Specific Information
Select
The component 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 component.
- 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 |