ODBC Driver for Oracle Service Cloud

Build 24.0.9060

OpportunityStatuses

The information about the default and custom opportunity statuses and their corresponding types.

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

Columns

Name Type Description
CreatedTime Datetime The date and time when the opportunity status was created. This attribute is read-only.
DisplayOrder Int The position of the opportunity status in the folder list.
Id [KEY] Long The unique identifier of the opportunity status.
LookupName String The name used to look up the opportunity status.
Name String The name of the opportunity status in the language of the current interface.
StatusTypeId Long Id of statusType. The current status and associated status type.
StatusTypelookUpName String LookUpName of statusType. The current status and associated status type.
UpdatedTime Datetime The date and time when the opportunity status was last updated. 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, one for each supported language.

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