AnalyticsReports
The analytics report definition that provides descriptions of a report's output columns, search criteria, and other components.
Table-Specific Information
SELECT
The add-in 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 add-in.
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |