TimesheetsDeleted
Query the Project Notes in TSheets.
Table Specific Information
Select
Query the TimesheetsDeleted table. The adapter will use the API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the adapter.
- 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. |