Tasks
Retrieves tasks from Streak.
Table Specific Information
Select
Streak allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can typically be used with only = comparision. The available columns for Tasks are TaskKey and BoxKey. For example:
SELECT * FROM Tasks WHERE TaskKey='agxzfm1haWxmb29nYWVabAsSDE9yZ2FuaXphdGlvbiIJY2RhdGEuY29tDAsSBFRhc2sYgIDs0NySvQsM' SELECT * FROM Tasks WHERE BoxKey='agxzfm1haWxmb29nYWVyLAsSDE9yZ2FuaXphablvbiIJY2RhdGEuY29tDAsSBENhc2UYgICs7-O4mwsM'
Columns
| Name | Type | References | Description |
| TaskKey [KEY] | String | Key of the task. | |
| BoxKey | String |
Boxes.BoxKey | The box the task is in. |
| PipelineKey | String |
Pipelines.PipelineKey | The pipeline the task is in. |
| CreatorKey | String |
Users.UserKey | The user who created the task. |
| CreationDate | Timestamp | When the task was created. | |
| LastStatusChangeDate | Timestamp | When the status last changed. | |
| DueDate | Timestamp | When the task is due and a reminder is sent. | |
| SortOrder | String | Sort order of the task. | |
| Text | String | The text of a task. | |
| Status | String | Whether the task is DONE or NOT_DONE. | |
| ReminderStatus | String | Gets the status of the reminder if this task has to be done. Can be: NONE, SCHEDULED, REMINDED or ERROR_ON_REMINDER. | |
| AssignedToSharingEntries | String | Who the task is assigned to. | |
| CreatorSharingEntry | String | User who created the sharing entries. | |
| LastSavedTimestamp | Timestamp | When the task was last saved. |