Holidays
The list of holidays in your organization.
Table-Specific Information
SELECT
The add-in will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the add-in.
SELECT * FROM Holidays WHERE id = 12 SELECT * FROM Holidays WHERE id > 15 SELECT * FROM Holidays WHERE lookUpName LIKE '%test' SELECT * FROM Holidays WHERE id IN (12, 23, 123) SELECT * FROM Holidays WHERE lookUpName IS NOT NULL
INSERT
INSERT can be executed by specifying the holidayDate and name columns. The columns that are not read-only can be inserted optionally. Following is an example of how to insert into this table.
INSERT INTO Holidays (holidayDate, name) VALUES ('2011-01-17', 'testinsert')
UPDATE
Update can be executed by specifying the id column in WHERE Clause. The columns that are not read-only can be Updated.
For example:
UPDATE Holidays SET holidayDate = '2012-01-17' WHERE id = '1'
DELETE
Following is an example of how to Delete a record in this table.
DELETE FROM Holidays WHERE holidayDate = '2012-01-17'
Columns
| Name | Type | ReadOnly | Description |
| CreatedTime | Datetime | True |
The date and time when the holiday was created. This attribute is read-only. |
| DisplayOrder | Int | False |
The display position relative to other holidays. |
| HolidayDate | Date | False |
The date the holiday falls on. The maximum allowed value of the date is 12/31/2032. |
| Id [KEY] | Long | True |
The unique identifier of the holiday. |
| LookupName | String | True |
The name used to look up the holiday. |
| Name | String | False |
The name of the holiday. |
| UpdatedTime | Datetime | True |
The date and time when the holiday was last updated. This attribute is read-only. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| adminVisibleInterfaces | String |
The list of interfaces on which the holiday is available for administration use. |