Tasks
Returns 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 who created the task. | |
| OwnerId | Integer | The Id of the user who owns 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, or 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, and Company. | |
| CreatedAt | Datetime | The date and time when the task was created. | |
| UpdatedAt | Datetime | The date and time when the task was last updated. | |
| RecordingId | Integer | The recording Id for the task. | |
| Public | Boolean | Indicates whether the task is visible to all members of the account. | |
| RecurringPeriod | Integer | The recurrence interval for the task. The allowed values are 0 (every day), 1 (every week), 2 (every two weeks), 3 (every month), 4 (every three months), 5 (every six months), and 7 (every year). Null when the task does not recur. | |
| AnchorType | Integer | The anchor used to schedule the next occurrence of a recurring task. The allowed values are 0 (time completed) and 1 (original due time). |