JDBC Driver for Oracle Service Cloud

Build 22.0.8462

AccountsEmails

The email address and its associated information.

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

Columns

Name Type Description
AccountsId Long Id of Accounts.
Address String The string value of the email address.
AddressTypeId Long Id of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
AddressTypelookUpName String LookUpName of addressType. The type of address, such as Primary or Alt1. This is the key for the list entry.
Certificate String The associated public email certificate used to encrypt outgoing emails.
Invalid Bool Indicates whether the email address is disabled.

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