Returns holidays configured for schedules, including name and date range details.

Table-Specific Information

Select

The following queries are processed server-side while other filters are processed client-side within the provider.

SELECT * FROM Holidays WHERE ScheduleId = '123'

SELECT * FROM Holidays WHERE ScheduleId = '123' AND Id = '456'

Insert

The ScheduleId, Name, StartDate, and EndDate columns are required to insert. This operation is allowed for logged-in users with the "admin" role only.

INSERT INTO Holidays (ScheduleId, Name, StartDate, EndDate) VALUES ('360000022454', 'Christmas', '2016-12-25', '2016-12-25')

Update

You must specify the ScheduleId and Id of the holiday to update. This operation is allowed for logged-in users with the "admin" role only.

UPDATE Holidays SET Name = 'Christmas', StartDate = '2018-12-25', EndDate = '2018-12-25'  WHERE ScheduleId = '123' AND Id = '456'

Delete

You must specify the ScheduleId and Id of the holiday to delete it. This operation is allowed for logged-in users with the "admin" role only.

DELETE FROM Holidays WHERE ScheduleId = '123' AND Id = '456'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		The Id automatically assigned when the holiday is created.
ScheduleId	Long	False	Schedules.Id	The Id of the schedule the holiday belongs to.
Name	String	False		The name of the holiday.
StartDate	Date	False		The date when the holiday starts.
EndDate	Date	False		The date when the holiday ends.