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. |