ConsoleConfiguration
Stores layout and configuration settings for the SugarCRM console interface. This table supports workspace customization and role-based dashboard experiences.
Columns
| Name | Type | ReadOnly | Description |
| Commentlog | String | True |
A free-form text field for storing internal comments that is related to the console configuration record. This field supports collaboration and operational note-taking. |
| Created_By | String | True |
The identifier (Id) of the user who created the console configuration record. This field supports auditing and ownership tracking. |
| Created_By_Name | String | True |
The display name of the user who created the console configuration record. |
| Date_Entered | Datetime | True |
The date and time when the console configuration record was created. |
| Date_Modified | Datetime | True |
The date and time when the console configuration record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the console configuration record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and data recovery. |
| Description | String | False |
A descriptive text field that provides additional detail about the purpose or configuration context of the console. |
| Enabled_Modules | String | False |
A list of modules that are enabled for display and interaction within the console. This configuration determines which business objects that users can view and manage. |
| Filter_Def | String | False |
The stored filter definition that is used to determine which records are included or excluded from the console view. This field controls data visibility and segmentation. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following the console configuration record. It returns a value of 'false' when the record is not being followed. |
| Freeze_First_Column | Bool | False |
A Boolean field that returns a value of 'true' when the first column in the console remains visible as the user scrolls horizontally. It returns a value of 'false' when all columns scroll normally. |
| Id [KEY] | String | True |
The unique Id of the console configuration record. |
| Locked_Fields | String | True |
A system-managed list of fields that are restricted from being edited. This field protects configuration integrity. |
| Modified_By_Name | String | True |
The display name of the user who last modified the console configuration record. |
| Modified_User_Id | String | True |
The Id of the user who last modified the console configuration record. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when the console configuration record is marked as a favorite by the current user. It returns a value of 'false' when the record is not marked as a favorite. |
| Name | String | False |
The user-defined or system-generated name of the console configuration record. This field is used for selection and identification. |
| Order_By_Primary | String | False |
The primary sort expression that is applied to data displayed in the console. This setting determines the primary ordering of records. |
| Order_By_Secondary | String | False |
The secondary sort expression applied when multiple records share the same primary sort value. |
| Sync_Key | String | True |
An internal synchronization key that is used to reconcile console configuration records across integrations or external systems. |
| Tag | String | False |
Tags that are assigned to the console configuration record. Tags support filtering, organization, and categorization. |