Cases
Create, update, delete, and query the Cases module in SugarCRM.
Columns
| Name | Type | ReadOnly | Description |
| My_Favorite | Bool | False |
Whether the record is a favorite for the user. |
| Following | Bool | False |
Whether the user is following this record. |
| Id [KEY] | String | False |
The unique identifier for the record. |
| Name | String | False |
The short description of the bug. |
| Date_Entered | Datetime | True |
The date the record was created. |
| Date_Modified | Datetime | True |
The date the record was last modified. |
| Modified_User_Id | String | True |
The Id of the user who last modified the record. |
| Modified_By_Name | String | True |
The user name who last modified the record. |
| Created_By | String | True |
The Id of the user who created the record. |
| Created_By_Name | String | True |
The user name of the user who created the record. |
| Doc_Owner | String | False |
The document owner. |
| User_Favorites | String | False |
The user favorites for the record. |
| Description | String | False |
The full text of the note. |
| Deleted | Bool | False |
Record deletion indicator. |
| Assigned_User_Id | String | False |
The user Id assigned to the record. |
| Assigned_User_Name | String | False |
The name of the user assigned to the record. |
| Team_Id | String | False |
The Id of the primary team. |
| Team_Set_Id | String | False |
The Id of the team set. |
| Team_Count | String | False |
The count of the team set. |
| Team_Name | String | False |
The name of the primary team. |
| Case_Number | Int | True |
The user-visible unique identifier for the case. |
| Type | String | False |
The type of issue (e.g., issue or feature). |
| Status | String | False |
The status of the case. |
| Priority | String | False |
The priority of the case. |
| Resolution | String | False |
The resolution of the case. |
| System_Id | Int | False |
The offline client device that created the bug. |
| Work_Log | String | False |
Free-form text used to denote activities of interest. |
| Account_Name | String | False |
The name of the associated account. |
| Account_Id | String | False |
The Id of the associated account. |
| Source | String | False |
An indicator of how the bug was entered (e.g., via Web or email). |
| Portal_Viewable | Bool | False |
Whether the case is viewable in the portal. |
| Escalation_Level_C | String | False |
The escalation level for the case. |