SSIS Components for Oracle Service Cloud

Build 24.0.9060

CountriesProvinces

The information about the provinces in the Countries/Provinces customizable menu.

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 CountriesProvinces WHERE id = 12
SELECT * FROM CountriesProvinces WHERE id > 15
SELECT * FROM CountriesProvinces WHERE name LIKE '%test'
SELECT * FROM CountriesProvinces WHERE id IN (12, 23, 123)
SELECT * FROM CountriesProvinces WHERE name IS NOT NULL

Columns

Name Type Description
CountriesId Long The unique identifier of the country.
DisplayOrder Int The display position relative to other provinces associated with the same country.
Id [KEY] Long The unique identifier of the province.
Name String The name of the province in the language of the current interface. 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
names String The list of names or labels for the province for each available language.

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