Returns time tracking entries for a given task.

Table Specific Information

Select

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

• 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 connector 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