SugarFavorites
Stores references to user-favorited records. This table supports quick navigation and personalized workspace organization.
Columns
| Name | Type | ReadOnly | Description |
| Assigned_User_Id | String | False |
The unique identifier (Id) of the user who is responsible for this favorite record. This assignment determines ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this favorite record. This value is shown in the user interface for clarity and reference. |
| Commentlog | String | True |
The comment log entries that are associated with this favorite record. This field stores collaboration notes, annotations, or historical context. |
| Created_By | String | True |
The Id of the user who created this favorite record. This value identifies the record author for auditing and lifecycle tracking. |
| Created_By_Name | String | True |
The display name of the user who created this favorite record. This value is shown in the user interface and reports. |
| Date_Entered | Datetime | True |
The date and time when this favorite record was created. This value supports timeline tracking and audit review. |
| Date_Modified | Datetime | True |
The date and time when this favorite record was most recently updated. This field supports version history and change transparency. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this favorite record is marked as deleted. It returns a value of 'false' when the record remains active and available. |
| Description | String | False |
The descriptive text that identifies or explains the purpose of this favorite entry. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this favorite record to receive activity updates. It returns a value of 'false' when the user is not following the record. |
| Id [KEY] | String | True |
The Id for this favorite record. This value is used to reference and manage the record throughout the system. |
| Locked_Fields | String | True |
The list of fields that are restricted from editing for this favorite record. This prevents modification of protected or system-managed values. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this favorite record. This provides visibility into update history. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this favorite record. This value identifies the source of the latest change. |
| Module | String | False |
The module where the associated record resides (for example, 'Accounts', 'Contacts', or 'Opportunities'). This value determines the record context. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the record is marked as a favorite by the current user. It returns a value of 'false' when it is not marked as a favorite. |
| Name | String | False |
The display name or label that is associated with this favorite record. This value is used for listing and navigation. |
| Record_Id | String | False |
The Id of the record that this favorite entry references. This value links the favorite to a specific item in the system. |
| Record_Name | String | True |
The display name of the record that this favorite entry references. This value is shown in user-facing lists and menus. |
| Sync_Key | String | True |
The synchronization key that is used to match this favorite record with external systems. This value supports data consistency across integrations. |