SSIS Components for Oracle Service Cloud

Build 24.0.9062

AnalyticsReports

The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components.

Table-Specific Information

SELECT

The 本製品 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 本製品.

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

Columns

Name Type Description
CreatedTime Datetime The date and time when the analytics report was created. This attribute is read-only.
Id [KEY] Long The unique identifier of the analytics report definition.
LookupName String The name used to look up the analytics report definition.
Name String The name of the report in the language of the current interface. This attribute is read-only.
UpdatedTime Datetime The date and time when the analytics report was last updated. This attribute is read-only.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
columns String The columns defined in the report.
filters String The filters defined on the report.
names String The list of language-specific display names.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062