JDBC Driver for SuiteCRM

Build 22.0.8462

Emails

Create, update, delete, and query the SuiteCRM Emails

Table Specific Information

Select

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

SELECT * FROM Emails WHERE Name = 'test'

Insert

Create an Email by specifying any writable column.

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

Update

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

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

Delete

Delete an Email by specifying the Id.

DELETE FROM Emails WHERE Id = '10003'

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier of the email.

Name String False

The subject of the email.

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 description for the email.

Deleted Bool False

The 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 Id of the user assigned to the record.

AssignedUserName String True

AssignedUserLink String True

Link to the user which the record has been assigned to

SecurityGroups String True

The security group associated with the record.

Orphaned Bool False

LastSynced Datetime False

FromAddrName String False

The from address in the email.

ReplyToAddr String False

The reply-to address in the email.

ToAddrsNames String False

The to addresses in the email.

CcAddrsNames String False

The cc addresses in the email.

BccAddrsNames String False

The bcc addresses in the email.

ImapKeywords String False

RawSource String False

The raw source for the email.

DescriptionHtml String False

The HTML description for the email.

DateSentReceived Datetime False

MessageId String False

The Id of the email item obtained from the email transport system.

Type String False

The type of the email (e.g., draft).

Status String False

The status of the record.

Flagged Bool False

The flagged status of the email.

ReplyToStatus Bool False

The reply-to status of the email. If you reply to an email then the reply-to status of original email is set.

Intent String False

The target of the action used in the Inbound Email assignment.

MailboxId String False

ParentName String True

The name of the parent of this account.

ParentType String False

The type of the Sugar module associated with the email. (Deprecated as of 4.2.)

ParentId String False

The Id of the parent of this account.

Indicator String False

Subject String False

Attachment String False

Uid String False

Msgno String False

Folder String False

FolderType String False

InboundEmailRecord String False

IsImported String False

HasAttachment String False

IsOnlyPlainText Bool False

Accounts String True

The accounts associated with the record

Bugs String True

The bugs associated with the record.

Cases String True

The cases associated with the record.

Contacts String True

The contacts associated with the record

Leads String True

The leads associated with the record.

Opportunities String True

The opportunities associated with the record.

Project String True

The project associated with the record.

Projecttask String True

Prospects String True

AosContracts String True

Tasks String True

The tasks associated with the record.

Users String True

Notes String True

The notes associated with the record.

Meetings String True

The meetings associated with the record.

CategoryId String False

EmailsEmailTemplates String True

EmailsEmailTemplatesName String True

EmailsEmailTemplatesIdb String True

OptIn String False

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