TDV Adapter for Oracle Service Cloud

Build 22.0.8462

StandardContentsContentValues

The standard content value with a data type and a formatted data value.

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

Columns

Name Type Description
StandardContentsId Long Id of StandardContents.
ContentTypeId Long Id of contentType. The content type of the data.
ContentTypelookUpName String LookUpName of contentType. The content type of the data.
Value String The formatted data for the associated content type.

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