Filters
Stores reusable filter and list-view configuration definitions. This table supports personalized data exploration, quick retrieval, and workflow efficiency.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this filter. These team names determine which teams have permission to view or apply the filter. |
| Acl_Team_Set_Id | String | False |
The Id of the team set that is associated with this filter. The team set defines all teams that are granted access to the filter. |
| App | String | False |
The application context in which this filter is available. This value determines where the filter can be accessed and used within SugarCRM. |
| Assigned_User_Id | String | False |
The Id of the user who is assigned responsibility for this filter. This user is typically the owner or primary maintainer of the filter. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned responsibility for this filter. This value is used in UI displays and reporting. |
| Created_By | String | True |
The Id of the user who created this filter record. This value supports auditing and historical tracking. |
| Created_By_Name | String | True |
The display name of the user who created this filter record. This value is shown in user-facing record details. |
| Date_Entered | Datetime | True |
The date and time when this filter record was created. This timestamp supports record history and chronological analysis. |
| Date_Modified | Datetime | True |
The date and time when this filter record was last modified. This timestamp supports change tracking and administrative review. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this filter record is marked as deleted in SugarCRM. It returns a value of 'false' when the record is active. |
| Description | String | False |
A descriptive note that explains the purpose, function, or intended use of this filter. This field is often used for documentation and collaboration. |
| Filter_Definition | String | False |
The stored filter logic that defines the conditions and criteria that are used to generate filtered results. This value controls which records are included when the filter is applied. |
| Filter_Template | String | False |
The filter layout or configuration template that is used for creating or reusing standard filter structures. |
| Following | Bool | False |
A Boolean field that returns a value of 'true' when the current user is following this filter. It returns a value of 'false' when the user is not following the filter. |
| Id [KEY] | String | True |
The unique identifier (Id) of this filter record. The system uses this Id to reference and manage the filter internally. |
| Locked_Fields | String | True |
The list of fields that are restricted from being modified in this filter. Locked fields help preserve business rules and prevent unauthorized changes. |
| Modified_By_Name | String | True |
The display name of the user who last modified this filter record. This value supports accountability and audit inspection. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this filter record. This value provides traceability for configuration updates. |
| Module_Name | String | False |
The module that is associated with this filter. This value determines the data set on which the filter is applied. |
| My_Favorite | Bool | False |
A Boolean field that returns a value of 'true' when this filter 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 of the filter. This value is shown in selection lists and user interfaces where the filter can be selected or reused. |
| Sync_Key | String | True |
The synchronization key that is used to align this filter record with external systems or integration workflows. |
| Team_Count | String | False |
The number of teams that are associated with this filter. This value helps assess collaboration and access scope. |
| Team_Id | String | False |
The Id of the primary team that is assigned to this filter record. The primary team controls the default visibility context. |
| Team_Name | String | False |
The display name of the primary team that is associated with this filter. This value appears in list views and assignment fields. |
| Team_Set_Id | String | False |
The Id of the team set that is assigned to this filter. The team set defines the full group of teams that can access or manage the filter. |