JDBC Driver for QuickBooks Time

Build 24.0.9062

JobcodeAssignments

Returns a list of all jobcode assignments associated with users.

Table Specific Information

Select

Query the JobcodeAssignments 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 本製品.

  • Id and UserId fields support the '=' and IN operators.
  • JobcodeId, JobCodeType, JobCodeParentId fields and ActiveStatus filter all support the '=' operator.
  • LastModified field supports the <=,<,>=,>,= operators.

For example, the following queries are processed server side:

SELECT * FROM JobcodeAssignments WHERE UserId IN (1242515, 1242515)

SELECT * FROM JobcodeAssignments WHERE JobCodeParentId = 17285791

Insert

Insert can be executed by specifying the UserId and JobcodeId columns. The columns that are not required can be inserted optionally. Following is an example of how to insert into this table

INSERT INTO JobcodeAssignments (UserId, JobcodeId) VALUES ('1234', '39')

Delete

Delete can be executed by specifying the Id in the WHERE Clause. For example:

DELETE FROM JobcodeAssignments WHERE Id = '41321421'

DELETE FROM JobcodeAssignments WHERE Id IN ('41321421', '41321435')

Columns

Name Type ReadOnly Description
Id [KEY] Int True

Id of jobcode assignment.

UserId Int False

Id of the user that this assignment pertains to.

JobcodeId Int False

Id of the jobcode that this assignment pertains to.

Active Boolean True

Whether or not this assignment is 'active'. If false, then the assignment has been deleted. true means it is in force.

LastModified Datetime True

Date/time when this jobcode assignment was last modified.

Created Datetime True

Date/time when this jobcode assignment was created

Pseudo-Columns

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

Name Type Description
JobCodeType String

Refers to the jobcode type - 'regular', 'pto', 'unpaid_break', 'paid_break', or 'all'. Defaults to 'regular'.

JobCodeParentId Integer

When omitted, all jobcode assignments are returned regardless of jobcode parent. If specified, only assignments for jobcodes with the given jobcode parent_id are returned. To get a list of only top-level jobcode assignments, pass in a jobcode_parent_id of 0.

ActiveStatus String

Filter column for whether to fetch only active records, only archived records, or both. By default, only active records are fetched. Possible values are: yes, no, both

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