TaskDetails

Holds detailed information for tasks, including attributes such as priority, due dates, and custom fields.

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.

TaskId supports the '=' operator.

For example, the following queries are processed server side:

SELECT * FROM TaskDetails WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'

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 TaskDetails SET Description = 'Task description', previewType = 'reference' WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'

Delete

Delete is not supported for this table.

Columns


Name	Type	ReadOnly	Description
CheckListId [KEY]	String	False	A unique identifier for the checklist, ensuring each checklist can be individually distinguished.
TaskId [KEY]	String	False	A unique identifier for the task associated with the checklist, linking it to its parent task.
isChecked	Bool	False	Indicates whether the checklist item is marked as completed (true) or pending (false).
checklist_lastModifiedBy_application_displayName	String	False	The display name of the application that last modified the checklist, providing traceability.
checklist_lastModifiedBy_application_id	String	False	The unique identifier of the application responsible for the last modification of the checklist, aiding in tracking changes.
lastModifiedDateTime	Datetime	False	The timestamp representing the most recent modification to the checklist, enabling version tracking.
orderHint	String	False	A hint value used to define the display order of checklist items relative to one another.
title	String	False	The title or name of the checklist item, summarizing its purpose or content.
description	String	False	A detailed description of the task, offering additional context or instructions.
previewType	String	False	Defines the type of preview displayed for the task, such as an image, link, or other content type.
references	String	False	A collection of related references or external resources linked to the task.
PlanId	String	False	A unique identifier for the plan to which the task belongs, ensuring proper association.