TaskAssignments
Displays a consolidated list of tasks assigned.
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 |
| TaskId [KEY] | String | The unique identifier for the task. |
| PlanId [KEY] | String | The unique identifier for the plan. |
| BucketId | String | The plan for the task assignment. |
| AssignedToUser [KEY] | String | The label assigned to User corresponds to this field. |
| AssignedByUserId | String | The label assigned by User ID corresponds to this field. |
| AssignedByUserName | String | The label assigned by User Name corresponds to this field. |
| AssignedDateTime | String | The time when the task was assigned. |
| OrderHint | String | The hint used to order assignees in a task. |