JDBC Driver for Zoho CRM

Build 24.0.9062

ActionsPerformed

Query information regarding performed actions.

Table-Specific Information

Select

The 本製品 uses the Zoho CRM API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the 本製品.

Note : ActionsPerformed cannot be queried until it is enabled from the UI.

SELECT * FROM ActionsPerformed

Columns

Name Type Description
Id [KEY] String The Id of the performed action.
ActionType String The type of the performed action.
Actions String The actions performed.
TimeSpent String The time spent performing the action.
ActionPerformedTime Datetime The date and time when the action was performed.
ParentID_Id String The Id of the parent object where the action was performed.
ParentID_Name String The name of the parent object where the action was performed.
ChatAttachment_Id String The Id of the chat attachment for the action.
ChatAttachment_Name String The name of the chat attachment for the action.

Pseudo-Columns

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

Name Type Description
DuplicateCheckFields String The field/s to be used for checking in an upsert.
CustomViewId Long The custom view Id to be used for filtering this record. Will work when useCOQL=false.

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