Cases
Create, update, delete, and query Cases that are visible to the authenticated user.
Table Specific Information
Insert
To insert a new Case, provide at least the Name:
INSERT INTO Cases (Name) values ('my case')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier for the case. | |
| Name | String | False |
The name of the case. | |
| IsClosed | Boolean | True |
Whether the case is closed. The default is open. | |
| ClosedAt | Datetime | False |
The date and time when the case was closed. | |
| VisibleTo | String | False |
Who the case is visible to: Everyone, Owner, or NamedGroup. | |
| OwnerId | Integer | False |
The unique identifier of the owner. | |
| GroupId | Integer | False |
The unique identifier of the group. | |
| AuthorId | Integer | False |
The unique identifier of the author. | |
| CreatedAt | Datetime | True |
The date and time when the case was created. | |
| UpdatedAt | Datetime | True |
The date and time when the case was last updated. |