OpportunitiesOtherContacts
The secondary contact associated with the opportunity.
Table-Specific Information
SELECT
The connector 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 connector.
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. |