Tasks
Retrieve Tasks created in the account.
Table Specific Information
Select
Retrieve all tasks that are visible to the current user
SELECT * FROM Tasks
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the task. | |
| AuthorId | Integer | The Id of the user that created the task. | |
| OwnerId | Integer | The Id of the user owning the task. | |
| Body | String | The instructions of the task. | |
| Frame | String | The description for the deadline of the task, such as today,tomorrow,this_week,next_week,later, overdue. | |
| CategoryId | Integer | The category id of the task. | |
| DoneAt | Datetime | The date and time when the task was completed. | |
| DueAt | Datetime | The date and time when the task is due for completion. | |
| AlertAt | Datetime | The date and time when the user will be alerted next about the task. | |
| SubjectId | Integer | The Id of the subject the task is created for. | |
| SubjectName | String | The Name of the subject the task is created for. | |
| SubjectType | String | The subject's type. The types are Case,People,Deal,Company | |
| CreatedAt | Datetime | The date and time when the task category was created. | |
| UpdatedAt | Datetime | The date and time when the task category was last updated. |