TaskAssignments
Create, update, delete, and query the available Task Assignments in Box.
テーブル固有の情報
Task Assignment は特定のユーザーにアサインされたタスクです。
Select
TaskAssignment テーブルのSelect には、Id もしくはTaskId を指定してください。
SELECT * FROM TasksAssignments WHERE Id = '123'
Insert
Task Assignment に挿入するには、Task（TaskId）とUser（AssignedToId） を紐付けます。
INSERT INTO TaskAssignments(TaskId, AssignedToId) VALUES(1001, 123)
Update
Task Assignment のメッセージ、もしくはそのResolutionState だけが更新できます。
UPDATE TaskAssignments SET Message = 'x', ResolutionState='completed' WHERE Id = '111'
Delete
Task Assignments は、Id を指定してDELETE ステートメントを発行することで削除できます。
DELETE FROM TaskAssignments WHERE Id = '111'
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | True |
The Id of the task assignment. |
| TaskId | String | False |
The Id of the task to assign. |
| AssignedToId | String | False |
The Id of the user to assign the task to. |
| AssignedToName | String | False |
The Name of the user the task is assigned to. |
| AssignedToLogin | String | False |
The Login of the user the task is assigned to. |
| ItemType | String | False |
The the type of the item the task assignment is connected to. |
| ItemId | String | False |
The the id of the item the task assignment is connected to. |
| ItemName | String | False |
The the name of the item the task assignment is connected to. |
| Message | String | False |
The message attached to the task assignment. |
| AssignedById | String | False |
The Id of the user that assigned the task. |
| AssignedByName | String | False |
The Name of the user that assigned the task. |
| AssignedByLogin | String | False |
The Login of the user that assigned the task. |
| AssignedAt | Datetime | True |
The date the task was assigned at. |
| RemindedAt | Datetime | True |
The date of the task reminder. |
| CompletedAt | Datetime | True |
The date the task was completed at. |
| ResolutionState | String | False |
Determines if the task has been attended to or not. 使用できる値は次のとおりです。completed, incomplete, approved, rejected |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AsUserId | String |
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts. |