TaskAssignments
Provides a unified view of all tasks assigned to various users, aiding in task tracking and accountability.
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: Lists data related to the groups that the user is a member of.
If Scope = AdminConsent: Lists all 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'
If no filter is provided, the add-in behaves differently based on AuthScheme. Authenticating as a user reads the assignments for the user's assigned tasks. When authenticating as a service principal, the add-in instead queries Tasks and reads the assignments for each task.
Columns
| Name | Type | Description |
| TaskId [KEY] | String | A unique identifier for the task within the system, used to distinguish it from other tasks. |
| PlanId [KEY] | String | A unique identifier for the plan to which this task belongs, linking tasks to their respective plans. |
| BucketId | String | The identifier for the bucket within the plan that organizes tasks into groups or categories. |
| AssignedToUser [KEY] | String | The user ID of the person to whom the task is assigned, indicating responsibility for completing the task. |
| AssignedByUserId | String | The user ID of the person who assigned the task, used for tracking task assignments. |
| AssignedByUserName | String | The name of the person who assigned the task, providing a human-readable reference for the assigner. |
| AssignedDateTime | String | The date and time when the task was assigned, enabling tracking of assignment history. |
| OrderHint | String | A value used to determine the display order of assignees within a task, allowing for prioritized arrangement. |