TDV Adapter for Oracle Service Cloud

Build 24.0.9060

ServiceCategoriesDescriptions

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 adapter will use the 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 adapter.

SELECT * FROM ServiceCategoriesDescriptions WHERE id = 12
SELECT * FROM ServiceCategoriesDescriptions WHERE id > 15
SELECT * FROM ServiceCategoriesDescriptions WHERE lookUpName LIKE '%test'
SELECT * FROM ServiceCategoriesDescriptions WHERE id IN (12, 23, 123)
SELECT * FROM ServiceCategoriesDescriptions WHERE lookUpName IS NOT NULL

Columns

Name Type Description
ServiceCategoriesId Long Id of ServiceCategories.
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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060