PlanDetails
Stores metadata and additional settings related to a specific plan, enhancing its customization and management.
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 |
PlanId [KEY] | String | False |
Unique identifier for the plan, used to distinguish it from other plans in the system. |
categoryDescriptions_category1 | String | False |
Indicates if the task is associated with the pink category, commonly used for color-coded task organization. |
categoryDescriptions_category10 | String | False |
Indicates if the task is associated with the gray category. |
categoryDescriptions_category11 | String | False |
Indicates if the task is associated with the silver category. |
categoryDescriptions_category12 | String | False |
Indicates if the task is associated with the brown category. |
categoryDescriptions_category13 | String | False |
Indicates if the task is associated with the cranberry category. |
categoryDescriptions_category14 | String | False |
Indicates if the task is associated with the orange category. |
categoryDescriptions_category15 | String | False |
Indicates if the task is associated with the peach category. |
categoryDescriptions_category16 | String | False |
Indicates if the task is associated with the marigold category. |
categoryDescriptions_category17 | String | False |
Indicates if the task is associated with the light green category. |
categoryDescriptions_category18 | String | False |
Indicates if the task is associated with the dark green category. |
categoryDescriptions_category19 | String | False |
Indicates if the task is associated with the teal category. |
categoryDescriptions_category2 | String | False |
Indicates if the task is associated with the red category, often symbolizing high-priority or critical tasks. |
categoryDescriptions_category20 | String | False |
Indicates if the task is associated with the light blue category. |
categoryDescriptions_category21 | String | False |
Indicates if the task is associated with the dark blue category. |
categoryDescriptions_category22 | String | False |
Indicates if the task is associated with the lavender category. |
categoryDescriptions_category23 | String | False |
Indicates if the task is associated with the plum category. |
categoryDescriptions_category24 | String | False |
Indicates if the task is associated with the light gray category. |
categoryDescriptions_category25 | String | False |
Indicates if the task is associated with the dark gray category. |
categoryDescriptions_category3 | String | False |
Indicates if the task is associated with the yellow category, often symbolizing caution or tasks requiring attention. |
categoryDescriptions_category4 | String | False |
Indicates if the task is associated with the green category, commonly used for tasks signaling progress or success. |
categoryDescriptions_category5 | String | False |
Indicates if the task is associated with the blue category, often representing trust or stability. |
categoryDescriptions_category6 | String | False |
Indicates if the task is associated with the purple category, typically used for strategic or creative tasks. |
categoryDescriptions_category7 | String | False |
Indicates if the task is associated with the bronze category. |
categoryDescriptions_category8 | String | False |
Indicates if the task is associated with the lime category. |
categoryDescriptions_category9 | String | False |
Indicates if the task is associated with the aqua category. |
sharedWith | String | False |
Lists the files or entities with which the plan is shared, enabling collaboration and visibility. |