CustomFieldItemUserFilters
Query the Custom Field Item User Filters in TSheets.
Table Specific Information
Select
Query the CustomFieldItemUserFilters 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.
- UserId supports the '='
- GroupId supports the '='
- IncludeUserGroup supports the '='
- LastModified supports the '<,<=,>,>='
For example, the following queries are processed server side:
SELECT * FROM CustomFieldItemUserFilters SELECT * FROM CustomFieldItemUserFilters WHERE JobCodeId = '679721'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of the JobCode to which the filter belong. |
| Type | String | The entities filter type: user or group. |
| 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 user 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 |
| UserId | Integer | Limits the returned filters to only those for the specified user_id. You can also include items for this user's group automatically if you include the include_user_group parameter. |
| GroupId | Integer | Limits the returned filter to only those for the specified group_id. |
| IncludeUserGroup | Boolean | Boolean value. If a user_id is supplied, will return filters for that user's group as well. |