JDBC Driver for Oracle Service Cloud

Build 22.0.8462

OrganizationsAddresses

The physical address of the 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 OrganizationsAddresses WHERE addresstypeId = 12
SELECT * FROM OrganizationsAddresses WHERE addresstypeId > 15
SELECT * FROM OrganizationsAddresses WHERE city LIKE '%test'
SELECT * FROM OrganizationsAddresses WHERE addresstypeId IN (12,23,123)
SELECT * FROM OrganizationsAddresses WHERE city IS NOT NULL

Columns

Name Type Description
OrganizationsId Long The unique identifier of the organization.
AddressTypeId Long Id of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry.
AddressTypelookUpName String LookUpName of addressType. The type of address, such as mailing, street, and so on. This is the key for the list entry.
City String The name of the city.
CountryId Long Id of country. The ID of the country.
CountrylookUpName String LookUpName of country. The ID of the country.
PostalCode String The postal code or ZIP code.
StateOrProvinceId Long Id of stateOrProvince. The ID of the state or province.
StateOrProvincelookUpName String LookUpName of stateOrProvince. The ID of the state or province.
Street String The street address.

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