ProjectActivities
Query the Project Activities in TSheets.
Table Specific Information
Select
Query the ProjectActivities table. The add-in will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- Id supports the '=,IN'
- ProjectId supports the '='
- ActivityType supports the '='
- LastModified supports the '<,<=,>,>='
- SupplementalData supports the '='
For example, the following queries are processed server side:
SELECT * FROM ProjectActivities WHERE ProjectId = 2056676 SELECT * FROM ProjectActivities WHERE ProjectId = 2056676 AND Id = 8375474
Columns
| Name | Type | Description |
| Id [KEY] | Integer | ID of this project activity. |
| UserId | Integer | Id of the associated user. |
| ProjectId | Integer | Id of the associated project. |
| Active | Boolean | Boolean value. If false, this project activity is considered archive. |
| UnreadRepliesCount | Integer | The count of unread replies. |
| Following | Boolean | Following. |
| ActivityType | String | Activity type. |
| LastModified | Datetime | Date/time when this project was last modified, in ISO 8601 format. |
| Created | Datetime | Date/time when this project was created, in ISO 8601 format. |
| ProjectActivityMetadata | String | Project activity metadata. |
| LinkedObjects | String | A key/value map of all the objects linked to this project and the corresponding object ids. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| SupplementalData | Boolean | Default value is 'yes'. Indicates whether supplemental data should be specified. |