AssetStatuses
The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service.
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 AssetStatuses WHERE id = 12 SELECT * FROM AssetStatuses WHERE id > 15 SELECT * FROM AssetStatuses WHERE lookUpName LIKE '%test' SELECT * FROM AssetStatuses WHERE id IN (12, 23, 123) SELECT * FROM AssetStatuses WHERE lookUpName IS NOT NULL
Columns
Name | Type | Description |
CreatedTime | Datetime | The date and time when the asset status was created. This attribute is read-only. |
DisplayOrder | Int | The display position relative to other asset statuses. |
Id [KEY] | Long | The unique identifier of the asset status. |
LookupName | String | The name used to look up the asset status. |
Name | String | The name of the asset status in the language of the current interface. |
StatusTypeId | Long | Id of statusType. The type associated with the status. |
StatusTypelookUpName | String | LookUpName of statusType. The type associated with the status. |
UpdatedTime | Datetime | The date and time when the asset 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. |