SSIS Components for Oracle Service Cloud

Build 24.0.9060

HolidaysAdminVisibleInterfaces

The named ID that can be included in a list.

Table-Specific Information

SELECT

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

SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId = 12;
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId > 15;
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesLookUpName LIKE '%test';
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesId IN (12, 23, 123);
SELECT * FROM HolidaysAdminVisibleInterfaces WHERE AdminVisibleInterfacesLookUpName IS NOT NULL;

Columns

Name Type Description
AdminVisibleInterfacesId [KEY] Long The unique identifier of the object. This is the key for the list entry.
AdminVisibleInterfacesLookUpName String The name used to look up the object.
HolidaysId Long The unique identifier of the object. This is the key for the list entry.
HolidaysLookUpName String The name used to look up the object.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060