ProjectReport
Retrieves a project report.
Table Specific Information
Select
Query the ProjectReport table to retrieve a project report, broken down by user, group or jobcode. 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. By default the report will include results for a time range within the last 30 days. You can filter by StartDate and EndDate filters to get a payroll report over a different time range.
- UserId, JobcodeId and GroupId fields support the '=' and IN operators.
- StartDate and EndDate fields support the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM ProjectReport WHERE GroupId IN (29474, 29474) SELECT * FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31'
Based on the columns selected in projection explicitly, the aggregated data displayed may change.
Aggregate projects metrics broken down by user id:
SELECT * FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31' SELECT UserId, TotalHours FROM ProjectReport WHERE StartDate = '2019-11-01' AND EndDate = '2019-12-31'
Aggregate project metrics broken down by jobcode id:
SELECT JobCodeId, TotalHours FROM ProjectReport
Aggregate payroll metrics broken down by group id:
SELECT GroupId, TotalHours FROM ProjectReport
Columns
Name | Type | Description |
UserId | Int | Id of the users these totals are calculated for. |
JobcodeId | Int | Id of the jobcode the metrics apply to. |
GroupId | Int | Id of the group the metrics apply to. |
StartDate | Date | Start of reporting timeframe. |
EndDate | Date | End of the payroll reporting timeframe. |
TotalHours | Double | Total number of hours per each user, group or jobcode. |