PlanDetails

Represents additional information about a plan.

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
PlanId [KEY]	String	False	Unique identifier for the plan.
categoryDescriptions_category1	String	False	A boolean value that indicates whether a task has the pink category.
categoryDescriptions_category10	String	False	A boolean value that indicates whether a task has the gray category.
categoryDescriptions_category11	String	False	A boolean value that indicates whether a task has the silver category.
categoryDescriptions_category12	String	False	A boolean value that indicates whether a task has the brown category.
categoryDescriptions_category13	String	False	A boolean value that indicates whether a task has the cranberry category.
categoryDescriptions_category14	String	False	A boolean value that indicates whether a task has the orange category.
categoryDescriptions_category15	String	False	A boolean value that indicates whether a task has the peach category.
categoryDescriptions_category16	String	False	A boolean value that indicates whether a task has the marigold category.
categoryDescriptions_category17	String	False	A boolean value that indicates whether a task has the light green category.
categoryDescriptions_category18	String	False	A boolean value that indicates whether a task has the dark green category.
categoryDescriptions_category19	String	False	A boolean value that indicates whether a task has the teal category.
categoryDescriptions_category2	String	False	A boolean value that is true if the task has the red category.
categoryDescriptions_category20	String	False	A boolean value that is true if the task has the light blue category.
categoryDescriptions_category21	String	False	A boolean value that is true if the task has the dark blue category.
categoryDescriptions_category22	String	False	A boolean value that is true if the task has the lavender category.
categoryDescriptions_category23	String	False	A boolean value that is true if the task has the plum category.
categoryDescriptions_category24	String	False	A boolean value that is true if the task has the light gray category.
categoryDescriptions_category25	String	False	A boolean value that is true if the task has the dark gray category.
categoryDescriptions_category3	String	False	A boolean value that is true if the task has the yellow category.
categoryDescriptions_category4	String	False	A boolean value that is true if the task has the green category.
categoryDescriptions_category5	String	False	A boolean value that is true if the task has the blue category.
categoryDescriptions_category6	String	False	A boolean value that is true if the task has the purple category.
categoryDescriptions_category7	String	False	A boolean value that is true if the task has the bronze category.
categoryDescriptions_category8	String	False	A boolean value that is true if the task has the lime category.
categoryDescriptions_category9	String	False	A boolean value that is true if the task has the aqua category.
sharedWith	String	False	Indicates that a plan is being shared with one or more files.