Retrieves a project report.
Table Specific Information
Query the ProjectReport table to retrieve a project report, broken down by user, group or jobcode. The driver will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver. 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
|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.|