JDBC Driver for Oracle Service Cloud

Build 22.0.8462

VariablesInterfaceValues

The interface-specific value of a variable.

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

Columns

Name Type Description
VariablesId Long Id of Variables.
InterfaceId Long Id of interface. The interface of the site.
InterfacelookUpName String LookUpName of interface. The interface of the site.
Value String The description of the interface.

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