JDBC Driver for Highrise

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462