Adhoc view not returning correct data from Timesheet domain

Document ID : KB000117584
Last Modified Date : 15/10/2018
Show Technical Document Details
Question:
What is the source of the Missing Time fields available in the Time Management domain for Ad Hoc Reporting?
Answer:
The source of the Missing Time fields available under the Time Management domain in Advanced Reporting is a complex query that involves a union. We get all the open time periods in general and then union that if a person did not actually create a timesheet yet. We cannot share the query syntax for this union from our product's source code, but this example from stack overflow shows the basic concept of what we do to get this information: https://stackoverflow.com/questions/25690293/joining-a-calendar-table-to-find-timesheet-missing-dates