OpportunityStatuses
The information about the default and custom opportunity statuses and their corresponding types.
Table-Specific Information
SELECT
The 本製品 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 本製品.
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| names | String | The list of names, one for each supported language. |