JDBC Driver for SugarCRM

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462