JDBC Driver for Oracle Service Cloud

Build 22.0.8462

OpportunitiesOtherContacts

The secondary contact associated with the opportunity.

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

Columns

Name Type Description
OpportunitiesId Long The unique identifier of the opportunity.
ContactId Long Id of contact. The ID of the contact. This is the key for the list entry.
ContactlookUpName String LookUpName of contact. The ID of the contact. This is the key for the list entry.
ContactRoleId Long Id of contactRole. The role of the contact in the opportunity process.
ContactRolelookUpName String LookUpName of contactRole. The role of the contact in the opportunity process.

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