TaskAssignments
Provides a unified view of all tasks assigned to various users, aiding in task tracking and accountability.
Table Specific Information
Select
The component 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 component.
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'
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. |