ProjectActivityReadTimes
Update and Query the ProjectActivity read time in TSheets.
Table Specific Information
Select
Query the ProjectActivityReadTimes 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'
- LatestReadTime supports the '<,<=,>,>='
- SupplementalData supports the '='
For example, the following queries are processed server side:
SELECT * FROM ProjectActivityReadTimes SELECT * FROM ProjectActivities WHERE Id = 8375474
Columns
Name | Type | Description |
Id [KEY] | Integer | ID of this project activity read time. |
ProjectId | Integer | Id of the associated project. |
UserId | Integer | Id of the associated user. Only the current user id is allowed. |
LatestReadTime | Datetime | Date/time when this project activity was last read. |
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. |