CustomQueries
Stores saved query definitions that are used for advanced filtering or custom reporting. This table supports analytics, integration queries, and dataset reusability.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
A system-managed list of team names that provides access to the custom query record. This field supports access control and user visibility enforcement. |
| Acl_Team_Set_Id | String | False |
The Id of the team set that is associated with the custom query record. Team sets allow multiple teams to share ownership and access permissions. |
| Created_By | String | True |
The unique identifier (Id) of the user who created the custom query record. This field supports audit tracking and accountability. |
| Custom_Query | String | False |
The SQL statement that is defined for the custom query. This query is executed by the SugarCRM reporting engine or custom data views. |
| Date_Entered | Datetime | True |
The date and time when the custom query record was created. |
| Date_Modified | Datetime | True |
The date and time when the custom query record was last modified. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when the custom query record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and administrative cleanup. |
| Description | String | False |
A free-form descriptive text field that explains the purpose, expected output, or usage context of the custom query. |
| Id [KEY] | String | True |
The unique Id of the custom query record. |
| List_Order | Int | True |
The position of this custom query in query dropdown lists. This value might be unused in newer SugarCRM interfaces. |
| Modified_User_Id | String | True |
The Id of the user who last modified the custom query record. This field supports change tracking and audit accountability. |
| Name | String | False |
The user-defined name of the custom query. This value identifies the query in user interfaces and reporting configuration. |
| Query_Locked | Bool | False |
A Boolean field that returns a value of 'true' when the SQL statement is locked to prevent editing. It returns a value of 'false' when the SQL statement can be modified. This field helps preserve validated or business-critical queries. |
| Query_Type | String | False |
A classification label that describes the type of query. This field is typically unused in current configurations. |
| Team_Count | String | False |
The number of teams that have access to the custom query record. |
| Team_Id | String | False |
The Id of the primary team that is associated with the custom query record. |
| Team_Name | String | False |
The display name of the primary team that is associated with the custom query record. |
| Team_Set_Id | String | False |
The Id of the team set that grants shared access permissions to the custom query record. |