CommentLog
Stores threaded conversation entries that are attached to SugarCRM records. This table supports collaboration, context sharing, and discussion history tracking.
Columns
| Name | Type | ReadOnly | Description |
| Created_By | String | True |
The identifier (Id) of the user who created the comment log entry. This field helps track authorship for auditing and collaboration purposes. |
| Created_By_Name | String | True |
The display name of the user who created the comment log entry. |
| Date_Entered | Datetime | True |
The date and time when the comment log entry was created. |
| Date_Modified | Datetime | True |
The date and time when the comment log entry was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the comment log entry is marked for deletion. It returns a value of 'false' when the entry remains active. This field supports soft-delete workflows and record recovery. |
| Description | String | False |
A longer descriptive text that is associated with the comment log entry. This field is often used to provide additional narrative or context. |
| Entry | String | False |
The text of the individual comment entry. This field contains the actual comment content contributed by a user. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the comment log entry. It returns a value of 'false' when the entry is not being followed. This field enables activity tracking and notification. |
| Id [KEY] | String | True |
The unique Id of the comment log entry. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from modification. This field is used to preserve data integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified the comment log entry. |
| Modified_User_Id | String | True |
The Id of the user who last modified the comment log entry. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the comment log entry is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. This feature helps users quickly locate frequently referenced entries. |
| Name | String | False |
The user-defined or system-generated name of the comment log entry. This value identifies the entry in lists and record views. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile comment log records across systems and integrations. |
| Tag | String | False |
Tags that are assigned to the comment log entry. Tags support categorization, search, and filtering operations. |