TDV Adapter for Oracle Service Cloud

Build 22.0.8462

ServiceCategoriesNames

The language-specific strings used for localization of fields.

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

Columns

Name Type Description
ServiceCategoriesId Long The unique identifier of the service category.
LabelText String The language-specific label text. The value cannot be null or empty.
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