JDBC Driver for Oracle Service Cloud

Build 22.0.8462

AssetStatuses

The status of the assets, namely product and services that are registered and tracked in Oracle B2C Service.

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 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.

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