Create, update, delete, and query the available Task Assignments in Box.
Table Specific Information
Task Assignments are Tasks assigned to a specific User.
To select from the TasksAssignments table you need to specify an Id or a TaskId.
SELECT * FROM TasksAssignments WHERE Id = '123'
To insert into Task Assignments you need to connect a Task (TaskId) with a User (AssignedToId).
INSERT INTO TaskAssignments(TaskId, AssignedToId) VALUES(1001, 123)
Only the Message of the Task Assignment or its ResolutionState can be updated.
UPDATE TaskAssignments SET Message = 'x', ResolutionState='completed' WHERE Id = '111'
Task Assignments can be deleted by providing an Id and issuing a DELETE statement.
DELETE FROM TaskAssignments WHERE Id = '111'
The Id of the task assignment.
The Id of the task to assign.
The Id of the user to assign the task to.
The Name of the user the task is assigned to.
The Login of the user the task is assigned to.
The the type of the item the task assignment is connected to.
The the id of the item the task assignment is connected to.
The the name of the item the task assignment is connected to.
The message attached to the task assignment.
The Id of the user that assigned the task.
The Name of the user that assigned the task.
The Login of the user that assigned the task.
The date the task was assigned at.
The date of the task reminder.
The date the task was completed at.
Determines if the task has been attended to or not.
The allowed values are completed, incomplete, approved, rejected.
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
The Id of the user you want to impersonate. Only works with Admin, Co-Admin and Service Accounts.