Query the Custom Field Item User Filters in QuickBooks Time.

Table Specific Information

Select

The add-in uses 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 = operator.
• GroupId supports the = operator.
• IncludeUserGroup supports the = operator.
• LastModified supports the <, <=, >, >= operators.

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.