JDBC Driver for Oracle Service Cloud

Build 22.0.8462

Holidays

The list of holidays in your organization.

Table-Specific Information

SELECT

The driver 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 driver.

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462