TimesheetsDeleted
Query the Project Notes in TSheets.
Table Specific Information
Select
Query the TimesheetsDeleted 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'
- UserId supports the '=,IN'
- JobcodeId supports the '=,IN'
- StartDate supports the '='
- EndDate supports the '='
- Type supports the '='
- LastModified supports the '<,<=,>,>='
- GroupId supports the '=,IN'
- Username supports the '='
- JobcodeType supports the '='
- SupplementalData supports the '='
Either StartDate and EndDate or Id is required to query the TimesheetsDeleted view. For example, the following queries are processed server side:
SELECT * FROM TimesheetsDeleted WHERE StartDate = '2023-02-01' AND EndDate = '2024-07-01' SELECT * FROM TimesheetsDeleted WHERE Id = 8375474
Columns
| Name | Type | Description |
| Id [KEY] | String | Id of the Project Note. |
| UserId | Integer | Id of the associated user. |
| JobcodeId | Integer | JobCode id. |
| StartDate | Datetime | Start date. |
| EndDate | Datetime | End date. |
| Duration | Int | Duration. |
| Date | Datetime | Date. |
| Tz | Int | Time zone. |
| TzStr | String | Time zone str. |
| Type | String | Type. |
| Location | String | Location. |
| Active | Boolean | Active. |
| Locked | String | Locked. |
| Notes | String | Notes. |
| LastModified | Datetime | Last modified date. |
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 |
| GroupId | Integer | Id of the associated groups. |
| Username | String | User name. |
| JobcodeType | String | Job code type. |
| SupplementalData | Boolean | Default value is 'yes'. Indicates whether supplemental data should be specified. |