PlanDetails

Represents additional information about a plan.

Table Specific Information

Select

The connector 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 connector.

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.