JDBC Driver for QuickBooks Time

Build 24.0.9062

CustomFieldItemUserFilters

Query the Custom Field Item User Filters in TSheets.

Table Specific Information

Select

Query the CustomFieldItemUserFilters table. The 本製品 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 本製品.

  • 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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062