CaseEvents
Create, update, delete, and query the events related to the SuiteCRM cases
Table Specific Information
Select
You can query the Case Events table using any criteria in the WHERE clause. The connector will use the SuiteCRM API to filter the results.
SELECT * FROM [Case Events] WHERE LBL_CASE_ID = 'caseId1'
Insert
Create a Case Event by specifying any writable column.
INSERT INTO [Case Events] (Name, LBL_CASE_ID) VALUES ('Major Event', 'caseId4')
Update
You can update any Case Events column that is writable, by specifying the Id.
UPDATE [Case Events] SET LBL_CASE_ID = 'caseId2' WHERE Id = 'Test123'
Delete
Delete a Case Event by specifying the Id.
DELETE FROM [Case Events] WHERE Id = '10003'
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | False |
The unique identifier of the case event. |
| Assignedto | String | True |
The Id of the user assigned to the record. |
| AssignedUserId | String | True |
The user name of the user assigned to the record. |
| CaseId | String | False |
The Id of the case the event is logged for |
| Case | String | False |
The name of the case the event is logged for |
| CreatedById | String | True |
The Id of the user who created the record. |
| CreatedByName | String | True |
The name of the user who created the record. |
| DateCreated | Datetime | False | |
| DateModified | Datetime | False | |
| Deleted | Bool | False |
The record deletion indicator. |
| Description | String | False |
Description of the case event |
| ModifiedById | String | True |
The Id of the user who last modified the record. |
| ModifiedByName | String | True |
The name of the user who last modified the record. |
| Name | String | False |
Name given for the case update |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Rows@Next | String |
Identifier for the next page of results. Do not set this value manually. |