ActionsPerformed
Query information regarding performed actions.
Table-Specific Information
Select
The connector 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 connector.
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. |