ScheduleCalendars
Retrieves a list of schedule calendars associated with your employees or company.
Table Specific Information
Select
Query the ScheduleCalendars table. 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.
- Id field supports the '=' and IN operators.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM ScheduleCalendars WHERE Id IN (72595, 72597) SELECT * FROM ScheduleCalendars WHERE LastModified < '2019-01-01 18:30'
Columns
Name | Type | Description |
Id [KEY] | Integer | Id of the schedule calendar. |
Name | String | The name of the schedule calendar. |
Created | Datetime | Date/time when this schedule calendar was created |
LastModified | Datetime | Date/time when this schedule calendar was last modified. |