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. |