CustomFieldItemJobCodeFilters
Query the Custom Field Item JobCode Filters in TSheets.
Table Specific Information
Select
Query the CustomFieldItemJobCodeFilters 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.
- JobCodeId supports the '=,IN'
- LastModified supports the '<,<=,>,>='
For example, the following queries are processed server side:
SELECT * FROM CustomFieldItemJobCodeFilters SELECT * FROM CustomFieldItemJobCodeFilters WHERE JobCodeId = '679721'
Columns
Name | Type | Description |
Id [KEY] | Integer | Id of the JobCode to which the filter belong. |
LastModified | Datetime | The latest date/time when one of the filtered items was updated. |
FilteredCustomFieldItems | String | Each entity represents a custom field's active filters where the key is the custom field id and the value is an array of item ids to which the jobcode is assigned. |
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 |
JobCodeId | Integer | Comma separated list of one or more jobcode ids you'd like to filter on. |