Tasks
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.
- TaskId supports the '=' operator.
- PlanId supports the '=' operator.
- UserId supports the '=' operator.
- BucketId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Tasks WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK' SELECT * FROM Tasks WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC' SELECT * FROM Tasks WHERE UserId = '92dfdfc6-f1d4-4965-9f71-30e4da4fa7fe' SELECT * FROM Tasks WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'
Insert
Required fields for an insert are: title and planId.
Optional: bucketId.
INSERT INTO Tasks (title, planId) VALUES ('test44', 'nETc1IDpYkmb1E17w8TxGmUAGFWC') INSERT INTO Tasks (title, planId, bucketId) VALUES ('test44', 'nETc1IDpYkmb1E17w8TxGmUAGFWC', 'ZfzKVriNQ0yzR4IqJp-8FWUADq0Y')
Update
Microsoft Planner allows updates for the title, bucketId, percentComplete, assigneePriority, conversationThreadId, orderHint, dueDateTime and startDateTime columns.
UPDATE Tasks SET assigneePriority = '8377555 94446!', bucketId = 'rWpNKGmHukm84GaiDF_ZL2UAOlMj', conversationThreadId = 'AAQkADlmMzE1ZGIzLWY3OTctNDcyMy1iYmNlLWNlZmNlZTc5', dueDateTime = '2019-09-30T14:49:23', orderHint = '343d 454fd!', startDateTime = '2019-07-31T14:49:23.269', title = 'updatedTask', percentComplete = '35' WHERE TaskId = '7POTl5DUfkOsgzptPrzdzGUAHy1z'
Delete
Tasks can be deleted by providing TaskId.
DELETE FROM Tasks WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK'
Columns
Name | Type | ReadOnly | Description |
activeChecklistItemCount | Int | False | |
appliedCategories | String | False | |
assigneePriority | String | False | |
assignments | String | False | |
bucketId | String | False | |
checklistItemCount | Int | False | |
completedBy_application_displayName | String | False | |
completedBy_application_id | String | False | |
completedDateTime | Datetime | False | |
conversationThreadId | String | False | |
createdBy_application_displayName | String | False | |
createdBy_application_id | String | False | |
createdDateTime | Datetime | False | |
dueDateTime | Datetime | False | |
hasDescription | Bool | False | |
orderHint | String | False | |
percentComplete | Int | False | |
planId | String | False | |
previewType | String | False | |
priority | Int | False | |
referenceCount | Int | False | |
startDateTime | Datetime | False | |
title | String | False | |
assignedToTaskBoardFormat_id | String | True | |
bucketTaskBoardFormat_id | String | True | |
details_id | String | True | |
progressTaskBoardFormat_id | String | True | |
TaskId [KEY] | String | False | |
UserId | String | False | |
Etag | String | False | |
GroupId | String | False |