TimesheetsDeleted
Query the Project Notes in TSheets.
Table Specific Information
Select
Query the TimesheetsDeleted table. The connector 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 connector.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |