JDBC Driver for Oracle Service Cloud

Build 22.0.8462

AssetsSLAInstances

The instance of a Service Level Agreement (SLA).

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

Columns

Name Type Description
AssetsId Long The unique identifier of the asset.
ActiveDate Date The date when the instance became active.
ExpireDate Date The date when the instance is scheduled to expire.
Id [KEY] Long The unique identifier of the SLAInstance.
NameOfSLAId Long Id of nameOfSLA. The SLA from which the instance was created.
NameOfSLAlookUpName String LookUpName of nameOfSLA. The SLA from which the instance was created.
RemainingFromCSR Int The number of remaining CSR incidents.
RemainingFromChat Int The number of remaining chat incidents.
RemainingFromEmail Int The number of remaining email incidents.
RemainingFromWeb Int The number of remaining web self-service incidents.
RemainingTotal Int The total number of remaining incidents.
SLASet Int The SLA set from which the instance was created.
StateOfSLAId Long Id of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.
StateOfSLAlookUpName String LookUpName of stateOfSLA. The current state of the SLA. The supported values are Inactive, Active, Expired, or Disabled.

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