JDBC Driver for Oracle Service Cloud

Build 22.0.8462

ServiceProductsDescriptions

The language-specific string used for localization. Labels are assembled in a list that is associated with a particular text field.

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

Columns

Name Type Description
ServiceProductsId Long Id of ServiceProducts.
LabelText String The label text.
LanguageId Long Id of language. The ID of the language. This is the key for the list entry.
LanguagelookUpName String LookUpName of language. The ID of the language. This is the key for the list entry.

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