TaskAssignments
null
Table Specific Information
Select
The add-in uses 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.
If Scope = NoAdminConsent, List the data related to the groups that the user is a member of.
If Scope = AdminConsent, List all the data related to groups.
- TaskId supports the '=' operator.
- PlanId supports the '=' and 'IN' operators.
- BucketId supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM TaskAssignments WHERE TaskId = 'BCrvyMoiLEafem-3RxIESmUAHbLK' SELECT * FROM TaskAssignments WHERE PlanId = 'nETc1IDpYk3r3e317w8TxGmUAGFWC' SELECT * FROM TaskAssignments WHERE PlanId IN ('nETc1IDpYk3r3e317w8TxGmUAGFWC', 'v8iK3uCb30C5I_ocMGu3SGUAHQLI', 't2eNwoPxpEqhZs38GwT1HWUADwjN') SELECT * FROM TaskAssignments WHERE BucketId = 'qIguxctMLEGHYhmgSVGSNGUAAZOZ'
Columns
Name | Type | Description |
PlanId [KEY] | String | |
BucketId | String | |
TaskId [KEY] | String | |
AssignedToUser [KEY] | String | |
AssignedByUserId | String | |
AssignedByUserName | String | |
AssignedDateTime | String | |
OrderHint | String |