Tasks
The tasks table contains data about specific todos (tasks) in a task (action) in the organization.
This table can be used to determine what todos have yet to be done or are completed, as well as metadata about the todo such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| resolved_by_id | The numerical identifier of the user that completed this todo. Relates to the id column in the users table. An ID of 1 typically means a machine-created resolution, such as over the API. |
INT4 | Yes |
| object_ref | Used internally to track which object caused a task to be resolved | INT4 | Yes |
| resolved | Whether this todo is resolved or not. | BOOL | Yes |
| resolved_at | The UTC timestamp when this todo was resolved. | TIMESTAMP | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| action_field_id | The numerical identifier of the todo item (action field) that was completed by this todo. Relates to the id column in the action_fields table. |
INT8 | Yes |
| action_entity_id | The numerical identifier of the entity/task relation this todo was completed on. Relates to the id column in the action_entities table. |
INT8 | Yes |