CustomFieldItemUserFilters
Query the Custom Field Item User Filters in TSheets.
Table Specific Information
Select
Query the CustomFieldItemUserFilters 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.
- 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. |