ActionsPerformed
Returns a chronological log of actions taken on CRM records, including user edits, automation updates, and deletions.
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 | Unique identifier for the performed action. |
| ActionType | String | Specifies the category or nature of the action performed. |
| Actions | String | Details of the specific actions taken. |
| TimeSpent | String | The amount of time spent performing the action. |
| ActionPerformedTime | Datetime | Date and time when the action was completed. |
| ParentID_Id | String | Identifier of the parent object associated with the performed action. |
| ParentID_Name | String | Name of the parent object associated with the performed action. |
| ChatAttachment_Id | String | Identifier of the chat attachment related to the action. |
| ChatAttachment_Name | String | Name of the chat attachment related to the action. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DuplicateCheckFields | String | Fields used to check for duplicate records during an upsert operation. |
| CustomViewId | Long | Identifier of the custom view used to filter this record. Applies when the useCOQL parameter is false. |