JDBC Driver for SuiteCRM

Build 22.0.8462

Cases

Create, update, delete, and query the SuiteCRM cases

Table Specific Information

Select

You can query the Cases table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM Cases WHERE Name = 'test' 

Insert

Create a Case by specifying any writable column.

INSERT INTO Cases (Id, Name) VALUES ('id', 'Energy')

Update

You can update any Case column that is writable, by specifying the Id.

UPDATE Cases SET Name = 'new name', Description = 'Desc' WHERE Id = 'Test123' 

Delete

Delete a Case by specifying the Id.

DELETE FROM Cases WHERE Id = 'account21'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier for the record.

Name String False

DateEntered Datetime False

The date the record was created.

DateModified Datetime False

The date the record was last modified.

ModifiedUserId String False

The Id of the user who last modified the record.

ModifiedByName String True

The name of the user who last modified the record.

CreatedBy String False

The Id of the user who created the record.

CreatedByName String True

The name of the user who created the record.

Description String False

The full text of the note.

Deleted Bool False

Record deletion indicator.

CreatedByLink String True

Link to the record who created it

ModifiedUserLink String True

Link to the record who modified it.

AssignedUserId String False

The user Id assigned to the record.

AssignedUserName String True

The name of the user assigned to the record.

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

CaseNumber String False

Type String False

The type of case.

Status String False

The status of the record.

Priority String False

The priority of the record.

Resolution String False

The resolution of the case.

WorkLog String False

Free-form text used to denote activities of interest.

SuggestionBox String False

AccountName String False

The name of the associated account.

AccountName1 String False

A second account for the case

AccountId String False

The Id of the associated account.

State String False

State the case is left in

CaseAttachmentsDisplay String False

CaseUpdateForm String False

ContactCreatedBy String True

ContactCreatedByName String True

ContactCreatedById String False

Tasks String True

The tasks associated with the record.

Notes String True

The notes associated with the record.

Meetings String True

The meetings associated with the record.

Emails String True

The emails associated with the record

Documents String True

The documents associated with the record.

Calls String True

The calls associated with the record

Bugs String True

The bugs associated with the record.

Contacts String True

The contacts associated with the record

Accounts String True

The accounts associated with the record

Project String True

The project associated with the record.

UpdateText String False

Text associated with an update on the case.

Internal Bool False

AopCaseUpdatesThreaded String False

AopCaseUpdates String True

AopCaseEvents String True

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