PlanDetails
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.
- 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_category10 | String | False | |
categoryDescriptions_category11 | String | False | |
categoryDescriptions_category12 | String | False | |
categoryDescriptions_category13 | String | False | |
categoryDescriptions_category14 | String | False | |
categoryDescriptions_category15 | String | False | |
categoryDescriptions_category16 | String | False | |
categoryDescriptions_category17 | String | False | |
categoryDescriptions_category18 | String | False | |
categoryDescriptions_category19 | String | False | |
categoryDescriptions_category2 | String | False | |
categoryDescriptions_category20 | String | False | |
categoryDescriptions_category21 | String | False | |
categoryDescriptions_category22 | String | False | |
categoryDescriptions_category23 | String | False | |
categoryDescriptions_category24 | String | False | |
categoryDescriptions_category25 | String | False | |
categoryDescriptions_category3 | String | False | |
categoryDescriptions_category4 | String | False | |
categoryDescriptions_category5 | String | False | |
categoryDescriptions_category6 | String | False | |
categoryDescriptions_category7 | String | False | |
categoryDescriptions_category8 | String | False | |
categoryDescriptions_category9 | String | False | |
sharedWith | String | False | |
PlanId [KEY] | String | False |