TimeTrackingEntries
Returns time tracking entries for a given task.
Table Specific Information
Select
The 本製品 will use the Asana API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.
- Id supports the '=' comparison.
- TaskId supports the '=' comparison.
For example, the following queries are processed server side:
SELECT * FROM TimeTrackingEntries WHERE Id = '1204862911885011' SELECT * FROM TimeTrackingEntries WHERE TaskId = '1203479447771600'
When executing a query without one of the above filters, due to the Asana API design, time tracking entries must be retrieved per task. The 本製品 will first query the
workspace to retrieve a list of projects. A separate request will then be made for each project to retrieve all the applicable tasks. Then requests to get time tracking entries on each task will be made. In theory, this is similar
to executing the following query:
SELECT * FROM TimeTrackingEntries WHERE TaskId IN (SELECT Id FROM Tasks)
Insert
TaskId is a mandatory column for inserting into TimeTrackingEntries table. For example:
INSERT INTO TimeTrackingEntries (TaskId, DurationMinutes, EnteredOn) VALUES ('1203125557018947', 3600, '2024-01-01')
Update
Following is an example of how to update a TimeTrackingEntries table:
UPDATE TimeTrackingEntries SET DurationMinutes = 4000, EnteredOn = '2023-01-01' WHERE Id = '1208387811113769'
Delete
Following is an example of how to delete from TimeTrackingEntries table:
DELETE FROM TimeTrackingEntries WHERE Id = '1208387811113769'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True |
Globally unique ID of the team. | |
ResourceType | String | True |
The base type of this resource. | |
CreatedBy | String | True |
A user object represents an account in Asana that can be given access to various workspaces, projects, and tasks. | |
CreatedByResourceType | String | True |
The base type of the CreatedBy user resource. | |
CreatedByName | String | True |
The user's name. | |
DurationMinutes | Integer | False |
Time in minutes tracked by the entry. | |
EnteredOn | Date | False |
The day that this entry is logged on. | |
CreatedAt | Datetime | True |
The time at which this resource was created. | |
TaskId | String | False |
The associated Task's object Id. The task is the basic object around which many operations in Asana are centered. | |
TaskResourceType | String | True |
The base type of the Task resource. | |
TaskName | String | True |
The name of the task. | |
TaskResourceSubtype | String | True |
The subtype of the Task resource. |